Post a Comment On: Blogpad

declare @id int

while exists(select 1 from #ids)
begin
select top 1 @id = id from #ids

--
-- do stuff
--

delete from #ids where id = @id
end