(Print this page)
Dynamic pivot query in SQL Server 2005
Published date:
Monday, September 24, 2007
On:
Moer and Éric Moreau's web site
Original URL:
http://www.emoreau.com/Entries/Blogs/2007/09/Dynamic-pivot-query-in-SQL-Server-2005.aspx
András Belokosztolszki discusses the PIVOT operator in SQL Server 2005, and suggests a novel approach to constructing the Dynamic SQL, using XML, that works around the PIVOT operator's innate restrictions.
http://www.simple-talk.com/community/blogs/andras/archive/2007/09/14/37265.aspx
(Print this page)