- DELETE T1 FROM [dbo].[GEBOS_Employee_Account] T1
- INNER JOIN [temp].[GEBOS_Employee_Account] T2
- ON T1.[PersNr] = T2.[PersNr]
- AND T1.[Day] = T2.[Day]
- AND T1.[AccountNr] = T2.[AccountNr]
- GO
- INSERT INTO [dbo].[GEBOS_Employee_Account]
- SELECT T1.* FROM [temp].[GEBOS_Employee_Account] T1
- GO
|