title: Trace a Hierarchy in a Table
body: <p>I have an "Employee" table with an "EmployeeID" column and a column representing Employee's 
     Boss (BossID) which in turn is an employee in the "Employee" table. How can I trace the hierarchy from a given "EmployeeID" to the top most Boss. I do not want a self join approach in this, also I am using SQL Server 2005.</p>
  
  <p>Thank you</p>
  
  <p>Manu</p>