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 |
|
sqlenthu
Starting Member
1 Post |
 Posted - 2008-06-20 : 07:04:23
|
| i have a table with fields employeeid and managerid. employeeId Managerid1 2 2 53 54 7 5 8if i pass manager id as 8 then i should get all employees directly or indirectly mapped to him.ie.manager id = 8then employees should be (5,3,2,1)Plz help |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-06-20 : 07:06:40
|
| http://support.microsoft.com/kb/248915 |
 |
|
|
|
|
|
Recursive select statement