am rezolvat cu:

if exists (select CustomerCode from STARE where CustomerCode = @CustomerCode and Stare = 0)
begin

select.....

insert....

update....

 update STARE
 set Stare = 1
 where CustomerCode = @CustomerCode

end

si tot asa if exists cu update stare la sfarsit pana unde se sfarseste while-ul

multumesc

alex.