... darkrealms ...

Forums before death by AOL, social media and spammers... "We can't have nice things"

comp.databases.ms-sqlserver

Notorious Rube Goldberg contraption

19,505 messages

[ << oldest | < older | list | newer > | newest >> ]

Message 17,687 of 19,505

Plamen Ratchev to All

Re: Pivoting a table

10 Nov 09 13:31:27

   fed52e24   
   From: Plamen@SQLStudio.com   
      
   You have to use dynamic SQL to generate the column names based on the last 13   
   dates. The following article will give you   
   an idea on how to implement that:   
   http://pratchev.blogspot.com/2008/12/dynamic-pivoting.html   
      
   But normally this type of column header formatting should be done client side.   
      
   --   
   Plamen Ratchev   
   http://www.SQLStudio.com   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)

[ << oldest | < older | list | newer > | newest >> ]