Geeks With Blogs

News My Blog has been MOVED to
Michael Freidgeim's OLD Blog My Blog has been MOVED to

One of my colleagues asked how to create SQL query to show results as columns of a row, that actually stored in multiple rows in the table. Other co-worker suggested to use cursor to manually generate required rows.
I’ve found a few links about SQL PIVOT.  
It is easy to start with

More detailed are articles written by Itzik Ben-Gan

How to use Pivoting Without Aggregation is described in

Posted on Saturday, May 12, 2012 7:34 PM SQL Server | Back to top

Comments on this post: Links about SQL PIVOT

No comments posted yet.
Your comment:
 (will show your gravatar)

Copyright © Michael Freidgeim | Powered by: