Excellent article on SQL Server 2005 Common Table Expressions

2006/08/02

He goes beyond the basic recursion examples to show several very useful
reasons to implement CTEs. If you're developing in SQL Server 2005,
this is a great article to get a better understanding of when to
implement CTEs.