Is It possible to Transpose Unlimited rows into column using PIVOT in SQL Server?
Is It possible to Transpose Unlimited rows into colu开发者_运维知识库mn through PIVOT in SQL Server? if YES then How? I need because i have huge number of cities in table so i can't add all cities in FOR City IN
of PIVOT.
Is It possible to convert Unlimited rows into column through PIVOT in SQL Server?
No. You can have max 4,096 columns in a select statement. http://msdn.microsoft.com/en-us/library/ms143432.aspx
精彩评论