CREATE PROCEDURE pcTreeView
AS
create table #tbTV
       (intID int null,
        intParID int null,
        chDesc varchar( 512 ) null,
        btHn bit default  0 ,
	intLev int null)
declare @intCount smallint 
declare @intLevel smallint 
select  @intCount= 1 , @intLevel =  1 

insert into #tbTV (intID,intParID,chDesc, btHn)
            select КодОписания,ВходитВ,Описание,Вручную
            from ОписаниеПодзадачи 
            where КодОписания = ВходитВ
update tbTV set intLev = @intLevel

SELECT @intCount = (select count(*)
                    from ОписаниеПодзадачи) - 
                   (select count(*)
                    from #tbTV)

while @intCount> 0 
begin
insert into #tbTV 
         (intID,intParID,chDesc, btHn)
            select КодОписания,ВходитВ,Описание,Вручную
            from ОписаниеПодзадачи 
            where  ВходитВ in (select op2.intID
            from #tbTV op2
            Where op2.intLev = @intLevel)
                  and КодОписания <> ВходитВ
set @intLevel = @intLevel + convert(smallint, 1 )
update #tbTV set intLev = @intLevel
where intLev is null

SELECT @intCount = (select count(*)
                    from ОписаниеПодзадачи) - 
                   (select count(*)
                    from #tbTV)
end

select * from #tbTV 

GO