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.

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:1999 recursive queries are almost a quarter century old. In this standard the recursive queries have the form of recursive common table expressions. In recent years vendors of almost all database ...

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 ...

Recursive Descent and Table-Driven Parsing This project implements parsers for arithmetic expressions using two different techniques: recursive-descent parsing and table-driven parsing. It ...