Jeff's SQL Server Blog

Random Thoughts & Cartesian Products with Microsoft SQL Server
posts - 157, comments - 2686, trackbacks - 64

My Links

Advertisement

News

Welcome to my weblog. My name is Jeff Smith, I am software developer in Boston, MA and I was recently named a 2009 SQL Server MVP. Check in frequently for tips, tricks, commentary and ideas on SQL Server and .NET programming.


Subscribe





Archives

Post Categories

Programming

Sports

SQL

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:

Print | posted on Thursday, July 12, 2007 9:24 AM | Filed Under [ CrossTabs / Pivoting Data SQL Server 2005 Links ]

Feedback

Gravatar

# re: SQL 2005 PIVOT Operator (link)

i want to know the pivot operator's syntax & its use.
3/18/2008 4:48 AM | mamata
Gravatar

# re: SQL 2005 PIVOT Operator (link)

Comment
10/6/2008 4:28 AM | C
Comments have been closed on this topic.

Powered by:
Powered By Subtext Powered By ASP.NET