One of the new features in SQL Server 2005 is Common Table Expressions or CTEs. These allow for a wide variety of queries that are very difficult to achieve in previous version of SQL Server. However it is the addition of recursive CTEs that really puts Read More...