Jeff's SQL Server Blog

Random Thoughts & Cartesian Products with Microsoft SQL Server
posts - 157, comments - 2698, 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
<< Data Types -- The Easiest Part of Database Design | Home | The "Nested WHERE-IN" SQL Anti-Pattern >>

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

Copyright © Jeff Smith