http://www.sqlmag.com/authors/author/author/5730607/rss/5730607en-USFri, 25 May 2012 08:23:02 GMTFri, 25 May 2012 08:23:02 GMThttp://www.sqlmag.com/article/tsql3/pivoting-the-dynamic-wayThe PIVOT statement is a great tool for presenting data in an easy-to-read format, but it has one key limitation: You must know about and include all the column names in the PIVOT query. You can work around this limitation with dynamic pivoting.]]>Mitchel SellersThu, 22 Oct 2009 00:00:00 GMThttp://www.sqlmag.com/article/tsql3/pivoting-the-dynamic-way