IFT_Controlling_Documents.sql 302 B

123456789
  1. DELETE T1 FROM [dbo].[IFT_Controlling_Documents] T1
  2. INNER JOIN [temp].[IFT_Controlling_Documents] T2
  3. ON T1.[Document Number] = T2.[Document Number]
  4. AND T1.[posting line] = T2.[posting line]
  5. GO
  6. INSERT INTO [dbo].[IFT_Controlling_Documents]
  7. SELECT T1.* FROM [temp].[IFT_Controlling_Documents] T1
  8. GO