SQL Simple Batch Delete

batchdelete.sql

declare 
    @CurCount int, @MaxCount int

set @CurCount = 0
set @MaxCount = 100000
set nocount on;

while 1 = 1
    begin
 
    delete top(1000) 
        [TableName]
    where 
        [SomeDateColumn] < dateadd(dd, -14, getdate()) -- Date column is just an example
 
    select @CurCount = @CurCount + 1000
    if @@rowcount = 0 break
    if @CurCount < = @MaxCount break
 
end