/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

5 votes140 views2 answers
Copy data from one database to another
SQL
15 votes148 views2 answers
Open postgress in terminal mac
SQL
10 votes141 views5 answers
Create table mysql query
SQL
0 vote171 views1 answer
Check command
SQL
0 vote146 views1 answer
Less than date query sqlachemy
SQL
1 vote153 views1 answer
Show per page table in xampp
SQL
0 vote137 views1 answer
Vbscript create ADODB.Connection
SQL
0 vote99 views1 answer
Mysqli or pdo
SQL
3 votes146 views1 answer
Sql replace character in string in all records
SQL
0 vote139 views1 answer
Why we have to set the password for my sql server
SQL