I have a table with EmpID, EmpName, DeptName, ManagerID --- What I need a query where I can get Manager's Name, Department and all direct and indirect reports of the manager. The query will have lot more rows than source table as Each employee can be linked directly to a supervisor and then indirectly to supervisors of the direct supervisor. A supervisor will have multiple rows, one row each for direct reports and row each for each of the indirect reports; the level is multiple level deep... Any help will be appreciated. Thank You.