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