title: Getting all the children of a parent using MSSQL query
body: <p>I have the following data in my database:</p>
  
  <pre><code>Parent      Child
  101         102
  101         103
  101         104
  101         105
  101         106
  </code></pre>
  
  <p>My parameter is 106. And using the parameter I want to retrieve all the other children under its parent which is 101. I tried using the recursive method but it didn't work given the following data. Is there another way to formulate a query? </p>