- DELETE T1 FROM [dbo].[IFT_Controlling_Documents] T1
- INNER JOIN [temp].[IFT_Controlling_Documents] T2
- ON T1.[Document Number] = T2.[Document Number]
- AND T1.[posting line] = T2.[posting line]
- GO
- INSERT INTO [dbo].[IFT_Controlling_Documents]
- SELECT T1.* FROM [temp].[IFT_Controlling_Documents] T1
- GO
|