|
Neena_2008
Starting Member
6 Posts |
 Posted - 12/02/2008 : 05:47:12
|
I am using SQL Server 2000
I hav a table like this
-----Table 1 :--------
MangerID EmpID
15 18
15 10
18 60
18 3084
60 78
60 57
A manager can be a supervisor as well as employee at the same time.I want to create a hierarchy report with the top level manager at the top & subordinates at the bottom.
I want a result like this :
Supervisor Sub1 Sub2 Sub3
15 18 3084 null
15 18 60 78
15 18 60 57
15 10 null null
Can any1 help me with a query?
|
|
Pls help
