MSMVPS.COM
The Ultimate Destination for Blogs by Current and Former Microsoft Most Valuable Professionals.
Sign in
|
Help
Home
Blogs
Media
Groups
All Tags
»
SQL Server
»
tsql
»
dynamic
(
RSS
)
Browse Site by Tags
Showing related tags and posts accross the entire site.
community
crosstab
pivot
Dynamic Crosstab with multiple pivot columns
Jeff Smith in his weblog showed how to generate Crosstab reports using a stored procedure. 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 CREATE procedure CrossTab ( @select varchar(2000)...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
(Weblog)
by
Anonymous
on 08-16-2007
Filed under: sql server, community, tsql, dynamic, pivot, crosstab
Page 1 of 1 (1 items)
Copyright © is the original authors. Blog site is an independent site not sponsored by Microsoft. The Yoda blog server and the Brianna SQL server would like to thank www.ownwebnow.com and www.exchangedefender.com. They wouldn't be here and broadcasting without the generosity of Vlad Mazek and his companies.