declare @i int,@done bit

select @i = 0, @done = false

while i<10

begin

try something

observe effects

modify approach

if works then

begin

set @done = 1

end

end

if not @done

seek help