/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

14 votes348 views1 answer
Oracle new column
SQL
0 vote342 views2 answers
How to install mssql on mac
SQL
0 vote310 views1 answer
Mysql max number not returning correct value
SQL
0 vote312 views1 answer
Remove from table where
SQL
5 votes358 views2 answers
Sql constraint check value in list
SQL
0 vote347 views1 answer
. ERROR! The server quit without updating PID file (/usr/local/var/mysql/MacBook-Pro-de-Quentin.local.pid).
SQL
0 vote323 views1 answer
Sql server order by nulls last
SQL
7 votes387 views3 answers
Sql server check if temp table exists
SQL
0 vote318 views1 answer
Sql find table by name
SQL
2 votes332 views6 answers
In operator in sql
SQL