(Print this page)

Dynamic pivot query in SQL Server 2005
Published date: Monday, September 24, 2007
On: Moer and Éric Moreau's web site

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)