http://www.sqlmag.com/authors/author/author/5049304/rsscomment/5049304en-USFri, 25 May 2012 10:33:06 GMTFri, 25 May 2012 10:33:06 GMThttp://www.sqlmag.com/article/tsql3/create-pivoted-tables-in-3-steps#commentsAnchorMon, 13 Jul 2009 12:52:51 GMT
Kathi, Thank you for the excellent article on how to build a PIVOT query in 3 steps. Your step by step approach made it very easy to understand how to write a PIVOT query. I expect after reading your article people will be a lot less stressed and will have a good handle on resolving issues when they trying working through developing their PIVOT queries based on our article. I suppose it was a slight oversight on Microsoft’s behalf that BOL doesn’t state specifically that a CTE could be used as a data source for the PIVOT query. But to be fair to Microsoft they did state you can use a "derived table" as a table source for a PIVOT query. Since a CTE is a temporary named result set, one could argue (not that I am) this is a "derived table". One last note - It seems that callout "B" in listing 2 is missing the word "PIVOT" prior the first left parentheses ("("). But then again maybe I’ve missed the point of this listing. Thanks for the excellent article, Greg]]>GregMon, 13 Jul 2009 12:52:51 GMThttp://www.sqlmag.com/article/tsql3/create-pivoted-tables-in-3-steps#commentsAnchorhttp://www.sqlmag.com/article/tsql3/create-pivoted-tables-in-3-steps#commentsAnchorMon, 06 Jul 2009 16:47:40 GMT
Hi pzhu1968, Thanks so much for letting us know that the Download the Code link wasn’t working. The Download the Code link has been fixed. Thanks again! Megan Keller Associate Editor, SQL Server Magazine mkeller@sqlmag.com]]>MeganMon, 06 Jul 2009 16:47:40 GMThttp://www.sqlmag.com/article/tsql3/create-pivoted-tables-in-3-steps#commentsAnchorhttp://www.sqlmag.com/article/tsql3/create-pivoted-tables-in-3-steps#commentsAnchorMon, 06 Jul 2009 13:18:21 GMT
link for code download did not work.]]>PeiMon, 06 Jul 2009 13:18:21 GMThttp://www.sqlmag.com/article/tsql3/create-pivoted-tables-in-3-steps#commentsAnchor