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
|
WITH DATA AS (
SELECT [NUM_DV],[0],[1],[2],[3],[4]
FROM(
VALUES
('RPJMEA', NULL, NULL, NULL, NULL, NULL),
('RPJMEA', NULL ,NULL, NULL, NULL, 'PARIS MONTPARNASSE 1 ET 2'),
('RPJMEA', NULL, NULL, 'NANTES', 'PARIS MONTPARNASSE 1 ET 2', NULL),
('RPJMEA', 'ST NAZAIRE', 'NANTES', NULL, NULL, NULL)) AS DATA ([NUM_DV],[0],[1],[2],[3],[4]))
, PART1 AS
(
SELECT DATA.NUM_DV,[0],[1]
FROM DATA
WHERE [0] is not null and [1] is not null)
,PART2 AS
(SELECT DATA.NUM_DV,[2],[3]
FROM DATA
WHERE [2] is not null and [3] is not null)
SELECT PART1.NUM_DV,PART1.[0], PART1.[1], PART2.[2], PART2.[3]
FROM PART1
left outer join PART2 on PART1.NUM_DV=PART2.NUM_DV |
Partager