1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27
| DECLARE @table_de_depart TABLE
(
id char(4)
, region varchar(16)
)
INSERT INTO @table_de_depart
(
id
, region
)
VALUES ('AAAA','Sud')
, ('AAAA','Sud-Ouest')
, ('BBBB','Nord')
, ('CCCC','Est')
, ('CCCC','Sud')
, ('CCCC','Nord')
SELECT DISTINCT id
, LEFT(LR.liste_region, LEN(LR.liste_region) - 1) AS liste_region
FROM @table_de_depart AS TDD
CROSS APPLY (
SELECT region + ';'
FROM @table_de_depart AS S
WHERE TDD.id = S.id
FOR XML PATH('')
) AS LR(liste_region) |
Partager