Untitled

-- step 2: brisanje LogEntries tabele nakon ručnog prebacivanja podataka

DECLARE @LastId INT; 

SELECT @LastId = Id 
FROM [Audit].[LogEntriesHistory] 
ORDER BY [Id] DESC 
OFFSET 0 ROWS FETCH NEXT 1 ROWS ONLY;

PRINT CONCAT('Deleting rows in LogEntries with Id <= ', @LastId);

DELETE FROM [Audit].[LogEntries]  
WHERE [Id] <= @LastId;

PRINT CONCAT('Deleted rows in LogEntries with Id <= ', @LastId);