Using Pivot in SQL Server

Hi AmanSingh,

Refer below query.

SQL

DECLARE @Test AS TABLE(Id INT,ItemName VARCHAR(20),Quantity INT) 
INSERT INTO @Test VALUES(1,'ABC',10)
INSERT INTO @Test VALUES(2,'XYZ',20)
INSERT INTO @Test VALUES(3,'XYZ',30)
INSERT INTO @Test VALUES(4,'ABC',20)
SELECT * FROM @Test

SELECT ROW_Number() OVER (ORDER BY(SELECT 0)) ID,* FROM
(
    SELECT ItemName,Quantity FROM @Test
) as tbl
PIVOT(SUM(Quantity) FOR [ItemName] IN ([ABC],[XYZ])) as PVT

Input

Output