DELETE T1 FROM [dbo].[GEBOS_Account] T1 INNER JOIN [temp].[GEBOS_Account] T2 ON T1.[AccountNr] = T2.[AccountNr] GO INSERT INTO [dbo].[GEBOS_Account] SELECT T1.* FROM [temp].[GEBOS_Account] T1 GO