Following page has an example for dynamic crosstab:
http://www.sqlusa.com/bestpractices2005/dynamicpivot/
You can also build an SSRS report with dynamic columns.
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