/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 vote118 views1 answer
Sql server is not
SQL
0 vote147 views1 answer
Mysql date + 1 day
SQL
0 vote170 views1 answer
Laravel general error 2006 mysql server has gone away
SQL
36 votes229 views6 answers
Change column data type sql
SQL
0 vote178 views2 answers
Athena drop partition
SQL
0 vote158 views1 answer
Postgresql import data from csv
SQL
2 votes208 views3 answers
Xampp mysql database not starting
SQL
2 votes163 views1 answer
11:04:35 PM [mysql] Error: MySQL shutdown unexpectedly. 11:04:35 PM [mysql] This may be due to a blocked port, missing dependencies,
SQL
0 vote166 views1 answer
Oracle create package specification
SQL
0 vote161 views1 answer
Oracle execute immediate quotes
SQL