Jeff Smith Blog

Random Thoughts & Cartesian Products with Microsoft SQL Server

SQL 2005 PIVOT Operator (link)

There's two interesting posts over at the MSDN blogs from Craig Freedman about the new PIVOT operator in SQL 2005.  First, he gives a nice overview of the operator and how to use it, and then he follows it up with a performance analysis as well.  A good read, check it out. 

I hope to cover both the PIVOT and also the UNPIVOT operators a little myself at some point in a future post.

see also:

Legacy Comments

re: SQL 2005 PIVOT Operator (link)
i want to know the pivot operator's syntax & its use.

re: SQL 2005 PIVOT Operator (link)