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:42:13
|
I 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 : 06:12:22
|
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=115500 |
|
|
|
|
|