Mike Yearwood
Toronto, Ontario, Canada
General information
Forum:
Microsoft SQL Server
Environment versions
SQL Server:
SQL Server 2000
>I am trying to work out a situation in my head...
>
>I have 2 tables - A User table with UserID and UserName, and a UserSupervisor table with UserSupervisorID, UserID, SupervisorID.
>
>A user can have multiple supervisors, and a supervisor can have a supervisor. What I want to do is for a particular user, get all users above them. I know I am going to have to do a recursive lookup somehow. Is this something I need to do in a SPROC?
Google recursive, or hierarchical queries.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only