DECLARE @DATEHOURMAX datetime

DECLARE @HOURSTOADD int

DECLARE @DATEHOURSTART datetime

DECLARE @DATEHOURSTOP datetime 

SET @DATEHOURMAX = convert( datetime, ‘2007-11-22′, 120 ) 

– INITIALIZE VARIABLE

select top 1 @DATEHOURMAX = convert( datetime, date_field , 120) 

from tb_url_usage order by date_field

select top 1 @DATEHOURSTART = convert( datetime, date_field , 120)

from tb_url_usage order by date_field 

SET @DATEHOURSTOP = dateadd( day, -90, getdate()) 

– GET DATE 90 DAYS BACK

SET @HOURSTOADD = 0

WHILE @DATEHOURMAX < convert( datetime, @DATEHOURSTOP, 120 ) BEGIN

    SET @HOURSTOADD = @HOURSTOADD + 1

    SET @DATEHOURMAX = 

           dateadd( hour, @HOURSTOADD, @DATEHOURSTART)

    print CAST(@DATEHOURMAX as varchar(20))

    DELETE FROM tb_url_usage WHERE date_field < @DATEHOURMAX

    WAITFOR DELAY ‘00:00:01′  

    – PAUSE SCRIPT FOR 1 SEC.SO OTHERS CAN RUN

END 

print ‘Stop purge at: ‘

print @DATEHOURSTOP