Here are the links to the session I did at SQLBits Birmingham on 1st March on Making the Leap into Advanced TSQL; I looked at some of the table expressions available in SQL Server 2005 - Derived Tables, Temporary Tables and Common Table Expressions. I look at the basic framework and then go on into more...