/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 vote287 views2 answers
How covert into int in maria db
SQL
-1 vote285 views1 answer
Extract Data from SQL Server into XML Format
SQL
3 votes258 views1 answer
What is having clause
SQL
0 vote310 views1 answer
SQL Hello, [firstname] [lastname]
SQL
1 vote300 views1 answer
How to get the date diff on once field in sql server
SQL
0 vote275 views2 answers
What is the library that should import to use all functional database features in SQLite?
SQL
0 vote257 views1 answer
Mysql with
SQL
17 votes291 views4 answers
Sort by mysql
SQL
1 vote259 views1 answer
Sql group by error
SQL
-1 vote271 views1 answer
Insert results of a stored procedure into a temporary table
SQL