Interesting article, but I have a question, which hopefully will save me a lot of hours:

In Oracle 10 I do it in one select statement, using START WITH and CONNECT BY.

Now, migrating one of my customers to SQL 2008, is there anything close to it in SQL Server?

Thanks in advance