SQL Kiwi (5/16/2012)
Craig Freedman has a couple of great posts covering how recursive CTEs work:http://blogs.msdn.com/b/craigfr/archive/2007/10/25/recursive-ctes.aspx
http://blogs.msdn.com/b/craigfr/archive/2007/11/07/recursive-ctes-continued.aspx
I do wish folks would do a comparison against the equivalent While Loops to see just how bad recursion can actually be for reads and CPU.
--Jeff Moden
Change is inevitable... Change for the better is not.