Run in a loop and keep a list in a temporary table of the IDs you've already looked at, pulling each next iteration from the people that have supervisors in that temp table.<BR><BR>You can improve ...

SQL Server 2005 does have an answer though. Common Table Expressions, or CTEs, were introduced in SQL Server 2005, but they have not been getting the attention they deserve.

ANSI SQL 99 adds a recursive query capability which permits it.<BR><BR>SQL Server 2005 will add recursive query capability to T-SQL, but for no good reason doesn't use the ANSI syntax.