create procedure object_name @t int, @n varchar( 100 ) output
as
loop1:
select @n=@n+(select 
          tbl_name.objname
    from 
          tbl_name
    where
          tbl_name.objid = @t)+"  "             


select @t = (select 
          tbl_name.parentid
    from 
          tbl_name
    where
          tbl_name.objid = @t)     


if @t >  0 
goto loop1

SELECT                   
         object_name tbl_1.objid,
         tbl1.total
FROM
       tbl_1

create procedure object_name @t int, @n varchar( 100 ) output
as
loop1:
select @n=@n+(select 
          tbl_name.objname
    from 
          tbl_name
    where
          tbl_name.objid = @t)+"  "             


select @t = (select 
          tbl_name.parentid
    from 
          tbl_name
    where
          tbl_name.objid = @t)     


if @t >  0 
goto loop1



declare object_cursor cursor for
SELECT tbl_1.objid  FROM  tbl_1
for read only

open object_cursor

declare @error int 
declare @mm int

select @error =  0 
select @mm =  0 

CREATE TABLE #temp (id int, idname varchar( 100 ))

while  1 = 1 
begin
      fetch object_cursor into @mm
      if @@sqlstatus =  2  break
      if @@sqlstatus =  1 
      begin
             select @error =  1 
             raiserror  20000  'Ошибка ...'
             break
      end

      declare @gg varchar( 100 )
      select @gg = ''
      execute object_name @mm, @n = @gg output

      insert into #temp values (@mm, @gg)

end

close object_cursor

SELECT                   
         #temp.idname,
         tbl_1.total
FROM
       tbl_1, #temp
WHERE 
         tbl_1.objid = #temp.id