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.

A2: Establish a reference relationship and replace parent_product_identifier with the record of this table pointed to by the foreign key. A3: Add a calculated column and use the prior function to ...

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.

esProc SPL is a JVM-based programming language designed for structured data computation, serving as both a data analysis tool and an embedded computing engine. - From SQL to SPL：Total under recursive ...