>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?
Do you need to re-invent the wheel?
http://www.paragoncorporation.com/ArticleDetail.aspx?ArticleID=9or
http://www.mssqltips.com/tip.asp?tip=938or all other google results <g>
If it's not broken, fix it until it is.
My Blog