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
Id |
ItemName |
Quantity |
1 |
ABC |
10 |
2 |
XYZ |
20 |
3 |
XYZ |
30 |
4 |
ABC |
20 |
Output