I remember something from the SQL 2005 Launch about "Recursive queries based on common table expressions (CTE)". You can find more about this here: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/sql_05tsqlenhance.asp