/SQL/SQL Server dynamic pivot unknown number of columns

SQL Server dynamic pivot unknown number of columns

-   DECLARE @v_query  VARCHAR(8000) -- main query
    DECLARE @v_columns VARCHAR(8000) -- columns

    SET @v_columns =''

    -- Get string columns
    SELECT @v_columns += '[' + CONVERT(VARCHAR, Item) +'],' FROM (SELECT DISTINCT Item FROM #temp2) AS temp

    -- Delete the last comma
    SET @v_columns = LEFT(@v_columns,LEN(@v_columns)-1)


    -- Main query

    SET @v_query = 'SELECT Name, ' + @v_columns +' FROM
                    (
                        SELECT Name, Item FROM #temp2
                    ) T             
                    PIVOT
                    (
                        Count(Item)
                        FOR Item IN ('+ @v_columns +')
                    ) PVT'
    EXEC (@v_query)

Source: stackoverflow.com

Similar codes

1 vote293 views3 answers
Sql select only time from datetime
SQL
0 vote301 views2 answers
Oracle sql for each row
SQL
0 vote300 views2 answers
How covert into int in maria db
SQL
0 vote284 views1 answer
Jooq replace
SQL
0 vote292 views1 answer
Soql user profile
SQL
0 vote301 views1 answer
Drop domain postgresql
SQL
9 votes303 views2 answers
Sql limit to 5 results
SQL
0 vote372 views1 answer
How to subquey to do not load in live database in
SQL
10 votes320 views1 answer
Oracle view dependencies
SQL
1 vote294 views1 answer
Psql lst trigger
SQL