danielrolfe

declare @CleanupList table(ArchivalId uniqueidentifier)
declare @ArchivalId uniqueidentifier
insert into @CleanupList(ArchivalId) 
	select ArchivalId
	from dbo.Archive
	where ArchiveName = 'recyclebin'
while(1 = 1)
begin
    set @ArchivalId = NULL
    select top (1) @ArchivalId = ArchivalId