create proc rar22
(
@aoid varchar(2048),
@str varchar(2048),
@FORMALNAME varchar(2048),
@SHORTNAME varchar(2048),
@PARENTGUID varchar(2048)
)	
as
begin
select
@FORMALNAME = FORMALNAME,
@SHORTNAME = SHORTNAME,
@PARENTGUID = PARENTGUID
from FIAS_ADDROBJ
where AOID = @aoid

select @str = @FORMALNAME + ' '+ @SHORTNAME

while (@PARENTGUID <> '')
   select
   @FORMALNAME = FORMALNAME,
   @SHORTNAME = SHORTNAME,
   @PARENTGUID = PARENTGUID
   from FIAS_ADDROBJ
   where AOGUID = @PARENTGUID

   if @PARENTGUID <> ''
         select @str = @FORMALNAME + ' '+ @SHORTNAME
		 update rtt_net7 set fias_name= @str
		 
		

end