/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

0 vote270 views1 answer
Lost connection to mysql
SQL
0 vote247 views1 answer
How to solve ERROR 1049 (42000): Unknown database 'hbtn_0c_0'
SQL
5 votes229 views2 answers
Create table
SQL
4 votes234 views1 answer
Oracle show error line number
SQL
15 votes246 views2 answers
How to know the username of postgresql
SQL
7 votes234 views1 answer
Mysql unsafe update
SQL
0 vote250 views1 answer
PG::ForeignKeyViolation: ERROR: update or delete on table violates foreign key constraint
SQL
0 vote288 views1 answer
How to get table id sequence postgres
SQL
0 vote249 views1 answer
Sql server remove 0 from left
SQL
1 vote262 views1 answer
Change old domain to new domain name wordpress
SQL