microsoft.public.sqlserver.server - Help with this query!?

Author

Help with this query!?

Pablo Cordero

2002-06-25, 6:25 pm

I am looking for what I think is like a recursive query, I
have this table:

employee manager
-------- -------
emp1 man1
emp2 man2
man1 man3
man2 man4
man3 man5
....

i will like to get this:

emp1 man1
mqn1 man3
man3 man5

this is: the user enters the employee, and I should get
his manager, then the manager and the manager's manager,
and so on for 5 levels, how can I do that?

Thanks inadvance for the help

Pablo

Sponsored Links