1 2 3 4 5 6 7 8 9 10 11 12
| --------------------------------------index des stations --------------------------------------------------------
MERGE INTO [SERVER\MSSQLSERVERS].[GESTIONPETROLE].[dbo].[INDEXPARSTATION] AS target
USING OPENQUERY (
[DESKTOP-RSHSD6C\SQLEXPRESS],
'SELECT * FROM [DESKTOP-RSHSD6C\SQLEXPRESS].[GESTIONPETROLE].[dbo].[INDEXPARSTATION]'
) AS source
ON source.[Idindex]=target.[Idindex] AND target.[Dates]=source.[Dates] AND target.[INDEX]=source.[INDEX]
WHEN MATCHED THEN
UPDATE SET [Idindex]=source.[Idindex],[Dates]=source.[Dates],[IdCuve]=source.[IdCuve],[IDPRODUIT]=source.[IDPRODUIT],[IDPISTOLET]=source.[IDPISTOLET],[IDCLIENT]=source.[IDCLIENT],[INDEX]=source.[INDEX],[HEURS]=source.[HEURS]
WHEN NOT MATCHED BY TARGET THEN
INSERT ([Idindex],[Dates],[IdCuve],[IDPRODUIT],[IDPISTOLET],[IDCLIENT],[INDEX],[HEURS])
VALUES (source.[Idindex],source.[Dates],source.[IdCuve],source.[IDPRODUIT],source.[IDPISTOLET],source.[IDCLIENT],source.[INDEX],source.[HEURS]); |
Partager