1 2 3 4 5 6 7 8 9 10 11 12 13 14
| ;WITH Source AS ( SELECT 'aa' AS [A],'bb' AS [B],'cc' AS [C] ,'dd' AS [D] ,'ee' AS [E]
UNION ALL SELECT 'aa','ff','cc','gg','ee'
UNION ALL SELECT 'aa','ff','cc','gg','tt' -- doublon sur les 4 premières colonnes et UNION ALL --> crash imminent ! La clause NOT EXISTs ci-dessous n'y changera rien !
-- UNION ALL .... )
INSERT INTO [SAD].[dbo].[BMBOM]
(A, B, C, D, E)
SELECT [A], [B], [C], [D], [E]
FROM Source
WHERE NOT EXISTS (SELECT 1
FROM [SAD].[dbo].[BMBOM] T
WHERE T.[A] = Source.[A]
AND T.[B] = Source.[B]
AND T.[C] = Source.[C]
AND T.[D] = Source.[D]); |
Partager