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?