GEBOS_Employee_Account.sql 291 B

12345678910
  1. DELETE T1 FROM [dbo].[GEBOS_Employee_Account] T1
  2. INNER JOIN [temp].[GEBOS_Employee_Account] T2
  3. ON T1.[PersNr] = T2.[PersNr]
  4. AND T1.[Day] = T2.[Day]
  5. AND T1.[AccountNr] = T2.[AccountNr]
  6. GO
  7. INSERT INTO [dbo].[GEBOS_Employee_Account]
  8. SELECT T1.* FROM [temp].[GEBOS_Employee_Account] T1
  9. GO