Tag Archives: PIVOT

SoCal Code Camp 2011 Sessions Added

I have just submitted 2 sessions to the Southern California Code Camp, to be held in San Diego on June 25th & 26th.

Should you be interested in either (or both) topics and will be in the area that weekend, please register on the site and vote for them.

If you’re going to be in the area that weekend, I encourage you to attend as the variety of topics is quite broad. You’ll likely find many topics of interest among the submitted session abstracts.

Transact-SQL PIVOT & UNPIVOT redux

That was awesome!! The presentation went well, although it did go 2 minutes over. It’s hard to top the feeling you get when the audience is engaged and asking a lot of great questions.

I’m glad I went with PIVOT & UNPIVOT as my first presentation. By pure luck, a couple of people in the audience had just used PIVOT to solve a reporting problem with it and some others learned about it for the first time. Better yet, at least one of them will be using PIVOT right away in their own work to get rid of the CASE nest that you get if you don’t use these clauses.

Thank you SD SQL PASS chapter and especially all of you who came out on a work night to listen to me go on for 15 17 minutes. It’s ok, we all know you really showed up for the PowerPivot demo. Great job Lakshmi.

As promised, the slide deck and scripts are also available.


This pair of T-SQL commands always seem odd to cover in tandem because they’re not opposites. However, I feel like it’s more confusing to describe them apart from each other. Plus, it’s not like they don’t have any similarities.

Well, as promised, here are the slides and scripts from my presentation: T-SQL PIVOT & UNPIVOT (ZIP).

If you have any questions about the content, drop me a line.