Python-Projekte/tools/database/config/exec/GEBOS_Time_Tracking.sql

DELETE T1 FROM [dbo].[GEBOS_Time_Tracking] T1 
INNER JOIN [temp].[GEBOS_Time_Tracking] T2 
ON T1.[PersNr] = T2.[PersNr] 
AND T1.[Day] = T2.[Day] 
AND T1.[ActivityTypeNr] = T2.[ActivityTypeNr] 
AND T1.[StartingTime] = T2.[StartingTime] 
GO

INSERT INTO [dbo].[GEBOS_Time_Tracking]
SELECT T1.*, datepart(HOUR, T1.[Duration]) * 60 + datepart(MINUTE, T1.[Duration]) as Zeitdauer FROM [temp].[GEBOS_Time_Tracking] T1
GO