gctools/database/config/exec/GEBOS_Department.sql

DELETE T1 FROM [dbo].[GEBOS_Department] T1 
INNER JOIN [temp].[GEBOS_Department] T2 
ON T1.[DepartmentNr] = T2.[DepartmentNr] 
GO

INSERT INTO [dbo].[GEBOS_Department]
SELECT T1.* FROM [temp].[GEBOS_Department] T1
GO