Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
Neena_2008
Starting Member
6 Posts |
Posted - 2008-12-02 : 05:47:12
|
I am using SQL Server 2000I hav a table like this-----Table 1 :--------MangerID EmpID15 1815 1018 6018 308460 7860 57A 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 Sub315 18 3084 null15 18 60 7815 18 60 5715 10 null nullCan any1 help me with a query? |
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-02 : 05:58:43
|
see thishttp://www.sqlteam.com/forums/topic.asp?TOPIC_ID=109492 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
|
|