Declare @id int
declare @filename varchar(128)
declare @eof char(1)
set @eof ='N'
select id, filename from FaxLog where (Status='pass' or Status='fail') and FaxDeleted=0
while @eof='N'
begin
select top 1 @id=id,@filename=filename
from FaxLog
where (Status='pass' or Status='fail')
 and FaxDeleted=0
if @@ROWCOUNT=1
begin
   EXEC master..xp_deletefaxfiles @filename
   update FaxLog set FaxDeleted=1 where id=@id
End
Else
begin
   set @eof='Y'
end  
end