title: T-SQL request. Selecting "tree branch" from the table
body: <p>I`ve got a table with records linking to each other</p>
  
  <pre><code>name  id  manager_id
  ____________________
  adam  1   Null
  nick  2   1
  sten  3   1
  iren  4   3
  john  5   2
  steve 6   3
  </code></pre>
  
  <p>I want a Stored Procedure which will return a banch of managers for current worker. For example if i ask for Steve`s managers query result should look like that</p>
  
  <pre><code>steve 6 3
  sten  3 1
  adam  1 Null
  </code></pre>
  
  <p>How can it be done? 
  (it is not necessary to avoid loops for now)</p>