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