Python-Projekte/tools/database/config/IFT/exec/IFT_Actuals.sql

DELETE T1 FROM [dbo].[IFT_Actuals] T1 
INNER JOIN [temp].[IFT_Actuals] T2 
ON T1.[Document Number] = T2.[Document Number] 
AND T1.[Number of Line Item] = T2.[Number of Line Item]
AND T1.[Posting Date] = T2.[Posting Date]
GO

INSERT INTO [dbo].[IFT_Actuals]
SELECT T1.*, LEFT(T1.[Account Number GL], 7) FROM [temp].[IFT_Actuals] T1
GO