1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
| DECLARE @TEST TABLE (QUA_ID int, QUA_LAB varchar(50), QUA_LANG int)
INSERT INTO @TEST SELECT 1 ,'Test Fr',1
INSERT INTO @TEST SELECT 1 ,'Test En',2
INSERT INTO @TEST SELECT 1 ,'Test De',3
INSERT INTO @TEST SELECT 2 ,'Test 2 Fr ',1
INSERT INTO @TEST SELECT 2 ,'Test 2 En ',2
INSERT INTO @TEST SELECT 2 ,'Test 2 De ',3
INSERT INTO @TEST SELECT 3 ,'Test 3 Fr ',1
INSERT INTO @TEST SELECT 3 ,'Test 3 En ',2
INSERT INTO @TEST SELECT 3 ,'Test 3 De ',3
SELECT QUA_ID, [1] AS QUA_LA1, [2] AS QUA_LA2, [3] AS QUA_LA3
FROM
(
SELECT QUA_LAB, QUA_LANG, QUA_ID FROM @TEST
) As SourceTable
PIVOT
(
MAX(QUA_LAB) FOR QUA_LANG IN ([1], [2], [3])
) AS PIvotTable |
Partager