DELETE T1 FROM [dbo].[GEBOS_Employee_Account] T1 INNER JOIN [temp].[GEBOS_Employee_Account] T2 ON T1.[PersNr] = T2.[PersNr] AND T1.[Day] = T2.[Day] AND T1.[AccountNr] = T2.[AccountNr] GO INSERT INTO [dbo].[GEBOS_Employee_Account] SELECT T1.* FROM [temp].[GEBOS_Employee_Account] T1 GO