SQL loop to delete x rows at a time.

sqlLoopDeleteXRowsAtATime

DECLARE @rowCount INT
      , @rowsToDelete INT = 5000
      , @highestDate DATETIME2(7) = '2015-03-01'
      
      
WHILE 1 = 1
BEGIN
  DELETE TOP (@rowsToDelete) T FROM Table T
  WHERE T.DateTimeColumn < @highestDate
  
  SET @rowCount = @@ROWCOUNT
  
  IF @rowCount <> @rowsToDelete
    BREAK
END