http://www.sqlmag.com/authors/author/author/5049304/rss/5049304en-USFri, 25 May 2012 10:32:59 GMTFri, 25 May 2012 10:32:59 GMThttp://www.sqlmag.com/article/tsql3/create-pivoted-tables-in-3-stepsIf you want to create pivoted tables but found the PIVOT operator syntax in SQL Server Books Online (BOL) confusing, try this three-step approach to creating a PIVOT query. This query uses a common table expression (CTE).]]>Kathi KellenbergerTue, 23 Jun 2009 00:00:00 GMThttp://www.sqlmag.com/article/tsql3/create-pivoted-tables-in-3-steps