http://blogit.create.pt/blogs/ricardocosta/archive/2007/05/24/Recursive-Queries-in-SQL-Server-2005.aspxFor building recursive queries In SQL Server 2005 we have to use a new functionality called Common Table Expressions . Let's see how we can retrieve all the employees that report to a manager (ManagerID = 3) in the AdventureWorks database sample:enCommunityServer 2.1 (Build: 60809.935)