21 March 2008 08:05
tonyrogerson
SQLBits 20080301 - Birmingham; Making the Leap into Advanced TSQL
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 advanced uses like running totals and cumulative totals.
Presentation: http://sqlserverfaq.com/controls/kbase/store/downloads/SQLBits20080301MakingtheLeapintoAdvancedTSQL.ppt
Recording: http://sqlserverfaq.com/controls/kbase/store/downloads/SQLBits20080301WMV.zip
Sample DB: http://sqlserverfaq.com/controls/kbase/store/downloads/SQLBits20080301DB.zip
SQL Scripts: http://sqlserverfaq.com/controls/kbase/store/downloads/SQLBits20080301SQL.zip
Filed under: SQL Server, Presentation Decks, Data Cleansing, SQL Development, SQLBits