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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-12-26 : 13:00:05
|
maddie writes "Hello,
I have a simple text book recursive query question. The query I am interested in will find all manager levels (1st, 2nd, 3rd etc.,) for a specific employee id (ex: 1). I don't want to see all employees, but I am interested in seeing manager levels for a specific employee.
The Table: Employee
Colums: eeid, eename, eemgrid (this column has same data values as eeid).
data:
1, Joe, 2
2, John, 3
3, Marla, 4
4, BigBoss, null
If I ask for show me the manager levels (names) for Joe, then I should see all four records above.
Thanks,
Madeline" |
|
|
|
|
|
|
|
recursive query