quote:

---

Originally posted by cyborgnaren

SELECT
[SegmentS95Id] AS 'Seg'
,[MatS95Id] as 'Mat'
,[r_Use] AS 'Use'
,[Quantity] AS 'Qty'
FROM S95Definition

I get the below result
Seg Mat Use Qty
1815 FK19929 Con 1
1610 FK19929 Con 1
2400 FK19929 Pro 1
2400 FKFKFK Con 1
1410 FK19929 Con 1
1001 FK19929 Con 1
1210 FK19929 Con 1

I need the below result
Seg Mat-C C-Qty Mat-P P-Qty
1815 FK19929 1 NULL 0
1610 FK19929 1 NULL 0
2400 FK19929 1 FKFKFK 1
1410 FK19929 1 NULL 0
1001 FK19929 1 NULL 0
1210 FK19929 1 NULL 0

Any Help ?

---

SELECT Seg,
MAX(CASE WHEN Use='Con' THEN Mat END) AS [Mat-C],
MAX(CASE WHEN Use='Con' THEN Qty END) AS [C-Qty],
MAX(CASE WHEN Use='Pro' THEN Mat END) AS [Mat-P],
MAX(CASE WHEN Use='Pro' THEN Qty END) AS [P-Qty]
FROM
(Yourquery) q
GROUP BY Seg