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