Last week I presented at the March Minnesota SQL Server User Group (PASSMN) meeting on using CTEs in SQL Server. The session is meant as an overview and introduction to CTEs with some examples of their use and what some of the effects can be.
I found it to be a very interesting demonstration. My work still uses SQL 2000, but they’re looking to conver to 2008 later this year, so good.
Seemed like too much time was spent on the surface repeating examples when we could have gone further in depth.
For those that want to dig into some of the examples provided, here is the presentation for download.
I left one of the "less than happy" comments – my "criticism" was I like to walk away with some knowledge (and did) from the presentation, but also with something I can take to work the next day and use. Maybe a couple of different examples to make a common task simpler. But that is just my 2 cents.
I'll definitely be looking at ways to add something that can be taken away and immediately used. There was a script I included a couple times in the past that I removed due to its complexity. Maybe a simplier version of that would be useful to include.