while 1=1 begin delete top (5000) from tb where sysdate<='2013-12-31' if(@@rowcount<5000) break; waitfor delay '00:00:01' end