SQL Server PDW - PIVOT and UNPIVOT by rrchitturi

Active

Type:	Suggestion
ID:	766156
Opened:	10/4/2012 11:51:25 AM
Access Restriction:	Public

Workaround(s)

view

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.

Details (expand)

English

SQL Server PDW

Support PIVOT and UNPIVOT functions in future PDW releases.

Improved User Interface

0 attachments

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.

Regards,
- Artin

Microsoft