Friday, March 7, 2008 10:13 PM 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:

Comments

# Interesting Finds: March 8, 2008

Saturday, March 8, 2008 3:41 PM by Jason Haley

# summing values on the go in an SQL View... | keyongtech

Sunday, January 18, 2009 5:07 PM by summing values on the go in an SQL View... | keyongtech

Pingback from  summing values on the go in an SQL View... | keyongtech