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