Common Table Expressions at PASS

On Tuesday, I gave a presentation on SQL Server Common Table Expressions at the monthly meeting of the Fort Wayne chapter of PASS (Professional Association for SQL Server).

It was quite clearly a rousing success, well attended, and sure to be talked about long after Common Table Expressions become the subject of vintage technology jokes and bad career choices.

As promised at the presentation, I have posted here for download a .zip file of resources used in my presentation, including:

  • The PowerPoint (2007) Presentation
  • All SQL code demonstrated
  • My Notes (Word 2007)
For further exploration, here is a collection of relevant links that I found helpful in my quest for CTE knowledge.

…and if you made it to the presentation, thanks!