Home Forums SQL Server 2008 SQL Server 2008 - General Transpose Rows to Columns with first column values as column names from the table?? RE: Transpose Rows to Columns with first column values as column names from the table??
lynn.huff
Right there with Babe
Points: 784
More actions
November 28, 2012 at 8:08 am
#1563180
Outstanding! :-D:-D
I had not used Cross Apply before. Your idea of using Cross Apply, along with dynamically creating the column list for the pivot table solved my problem. 🙂
Thank you very much!