07 March 2008 22:13
tonyrogerson
SQLBits - My Session - Making the Leap into Advanced T-SQL
Got round to sorting the bits out, the session I did at SQLBits Birmingham on 1st March 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
Unfortunetly I had way too much content for the hour slot so over the coming weeks I'll be tayloring it, going into more depth in specific areas and removing some of the basic stuff ready for Scottish Developers Day on the 10th May.
Should also spurn a few blog posts.
Filed under: SQL Server