Geeks With Blogs

Michael Freidgeim's Blog MS .Net Development

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: | Join free