Pivot to 10000columns - by Wim SQL Server

Status : 


Sign in
to vote
ID 420980 Comments
Status Active Workarounds
Type Suggestion Repros 0
Opened 3/5/2009 8:19:19 AM
Access Restriction Public
Primary Feedback Item 127071


The developers write queries that pivot on all customer(eg. 10000) and so they get a table with 10000columns but only 5rows, while normally they had to pivot on A,B,C,D and E.
Is there a way to prevent the pivot on a list bigger > x?
Sign in to post a comment.
Posted by Microsoft on 3/10/2011 at 6:22 PM
I have resolved yours as duplicate of below:


We will use this request to track the overall PIVOT enhancements.

Umachandar, SQL Programmability Team
Posted by Microsoft on 3/9/2009 at 8:57 PM
Thanks for your feedback. You should consider implementing the check in your application when you generate the values in the PIVOT clause. SQL Server doesn't impose limits on the number of columns other than what we have for SELECT statement and so on. It is unlikely we will implement any special check for PIVOT. Lastly, we do not support SELECT triggers yet so you cannot do these checks.

Umachandar, SQL Programmability Team