Query to delete data before 90 days in 100-100 batches

AUTOMOTIVE

Written by:

December 19, 2021 

DECLARE @DELETED_ROWS INT;
SET @DELETED_ROWS = 100

WHILE (@DELETED_ROWS > 0)
BEGIN
    WITH cte AS
    (
         SELECT
             DATEADD(DAY, -90, UPDATEDDATE) AS date, audit_id 
         FROM
             auditdata 
    ) 
    DELETE TOP (100) 
    FROM cte 
    WHERE audit_id <= (SELECT MIN(audit_id) + 100 FROM cte) 

    SET @DELETED_ROWS = @@ROWCOUNT
END

Last modified: February 15, 2022

Perfect Research Base Study Related to the Paint Correction Terminology Previous Story:
Perfect Research Base Study Related to the Paint Correction Terminology
Why Should You Take Care Of Every Single Part Of Your Vehicle? Next Story:
Why Should You Take Care Of Every Single Part Of Your Vehicle?

About the Author /

Comments are closed.