SQLTeam.com | Weblogs | Forums

Creating a pivot table


That is what I thought they @debug was for. When I'm coding I always put in debug statements based off of a debug variable. Makes things so much easier debug and you don't have to remove them to move it into production.


Here are a couple of articles on the subject of "Crosstabs and Pivots". The first explains what they are, how they work, and which can be made to perform better using a wonderful thing known as "pre-aggregation" and contains code to easily duplicate the performance tests. The second article explains how to construct dynamic Crosstabs quite easily.



Jason's good code uses the CROSTAB method with the (2012 kicker known as CONCAT), which is the method I prefer.