Recursive Queries in SQL Server 2005

Lot of pain to get together SQL code in order to get a nice hierachy on your interface. Recursive stored procedures calls... limits to 32 inner recursive calls... bad performance, etc.

Here's what you can do from now on: recursive calls within queries.

Read the full atricle here.