Yes, you can build PIVOT dynamically either with the PIVOT statement or CASE expression:
http://www.sqlusa.com/bestpractices2005/dynamicpivot/
First develop the static SQL and test it. Then change it into dynamic.
Kalman Toth Database & OLAP Architect IPAD SELECT Query Video Tutorial 3.5 Hours
New Book / Kindle: Exam 70-461 Bootcamp: Querying Microsoft SQL Server 2012
No comments:
Post a Comment