SQL Server PDW - PIVOT and UNPIVOT - by rrchitturi

Status : 

  Fixed<br /><br />
		This item has been fixed in the current or upcoming version of this product.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 766156 Comments
Status Closed Workarounds
Type Suggestion Repros 3
Opened 10/4/2012 11:51:25 AM
Access Restriction Public


PIVOT and UNPIVOT functions that are supported in SQL Server are not functional in PDW. This request is to enable same in future releases.

Currently using Nexus result set pivot to certain extent.
Sign in to post a comment.
Posted by George Walters on 11/16/2015 at 6:05 AM
This is slowing down a proof of concept for a customer who wishes to spend a million dollars. Pivot and unpivot would speed up this POC.
Posted by Microsoft on 10/15/2012 at 9:20 PM
Hi Raja -
this is great feedback. In fact, we are seeing more customers requesting PIVOT/UNPIVOT. While it's currently not in scope for PDW V2, I can assure you that it will have a high ranking for coming AU's of V2.

- Artin