posted on Friday, August 10, 2007 4:28 AM by Madhivanan

Dynamic Crosstab with multiple PIVOT Columns

My blog has moved to http://sqlblogcasts.com/blogs/Madhivanan
The full version of this post can be found here,  http://sqlblogcasts.com/blogs/madhivanan/archive/2007/08/27/dynamic-crosstab-with-multiple-pivot-columns.aspx The new RSS feed is here

Jeff Smith in his weblog showed how to generate Crosstab reports using a stored procedure. It works only for one PIVOT Column.I had a requirement to generate crosstab reports with more than one pivot column. So I used the same approach he used and modified his procedure as shown below

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/madhivanan/archive/2007/08/27/dynamic-crosstab-with-multiple-pivot-columns.aspx

Comments

# re: Dynamic Crosstab with multiple PIVOT Columns @ Saturday, August 11, 2007 10:25 PM

Its always interesting to see people reinvent the wheel when everything that could be done with crosstabs was done in a rather painless way years ago. For the price of a lunch PMS (pivot madness syndrome) could be eliminated by taking a bite of RAC @

www.rac4sql.net

Steve Dassin

# re: Dynamic Crosstab with multiple PIVOT Columns @ Sunday, August 12, 2007 4:41 AM

Good one!

As for Steve for his product, it's still not available for SQL 2k5 and inbuilt function for pivot in 2k5 just sux!

hr_sn