FREE AI-Enhanced Online SQL Server Compiler

Untitled*

You must execute the code again to save those values in the database.

SET QUOTED_IDENTIFIER ON;

-- Sample table
CREATE TABLE YourTable (
    Column01 VARCHAR(50),
    Column02 INT,
    Column03 VARCHAR(50)
);

-- Inserting sample data
INSERT INTO YourTable (Column01, Column02, Column03)
VALUES
    ('Item01', 0, 'None'),
    ('Item02', 1, 'Med'),
    ('Item03', 2, 'None'),
    ('Item04', 0, 'Med'),
    ('Item05', 7, 'Bad'),
    ('Item06', 1, 'Good');

-- Query to pivot the data
DECLARE @columns NVARCHAR(MAX), @sql NVARCHAR(MAX);

SET @columns = STUFF((
        SELECT DISTINCT ',' + QUOTENAME(Column01)
        FROM YourTable
        FOR XML PATH (''), TYPE
    ).value('.', 'NVARCHAR(MAX)'), 1, 1, '');

SET @sql = '
    SET QUOTED_IDENTIFIER ON;
    SELECT ' + @columns + '
    FROM (
        SELECT Column01, Value, RowNum
        FROM (
            SELECT Column01, CAST(Column02 AS VARCHAR(MAX)) AS Column02, CAST(Column03 AS VARCHAR(MAX)) AS Column03
            FROM YourTable
        ) AS Source
        UNPIVOT (
            Value FOR RowNum IN (Column02, Column03)
        ) AS unpivoted
    ) AS Source
    PIVOT (
        MAX(Value) FOR Column01 IN (' + @columns + ')
    ) AS PivotTable';

-- Execute dynamic SQL
EXEC sp_executesql @sql;

Item01 Item02 Item03 Item04 Item05 Item06
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
0 1 2 0 7 1
None Med None Med Bad Good