Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 SQL Server 2005 Dynamic Pivots

Author  Topic 

Shrews14
Starting Member

37 Posts

Posted - 2007-08-20 : 12:07:05
I'm trying to create a dynamic pivot table, with changing column headers eg. dates!!? how can this be done when you have to define the headers names in the query!

More info availible if any one can help!!

thanks for your time

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-08-20 : 12:12:18
Look at the "FAQ" topic in this forum. There are plenty of dynamic pivot queries.



E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2007-08-21 : 04:06:07

http://weblogs.sqlteam.com/jeffs/archive/2005/05.aspx

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -