Transpose the result of dynamic SQL query

Asked Jul 25 '14 at 13:25

Active Jul 25 '14 at 13:25

Viewed 89 times

I use dynamic SQL to run a query:

    select @query = '
    SELECT C.LdcCode, ' + @cols + '
    FROM DailyTimesheetUnprocessedCount AS C
    LEFT OUTER JOIN #LdcSorting AS S
        ON C.LdcCode = S.LdcCode
    GROUP BY C.LdcCode, S.SortOrder
    ORDER BY ISNULL(S.SortOrder, 100)
    '

    execute(@query)

Is there a simple way to transpose the results of the query, so in my case LdcCodes would be column names, and what is now in @cols would be values in the first column?

Thanks.

asked Jul 25 '14 at 13:25

David Shochet

5,035
11
57
105

1

Look into [pivot](http://stackoverflow.com/search?q=pivot). Tons of questions already on SO about it. – Andrew Jul 25 '14 at 13:28
1

Here's an example of a dynamic pivot: http://stackoverflow.com/questions/10404348/sql-server-dynamic-pivot-query – Nick Vaccaro Jul 25 '14 at 13:40
Thanks everybody! It works. – David Shochet Jul 25 '14 at 13:58

Transpose the result of dynamic SQL query

0 Answers0