set nocount on 

declare @ms table(id int, parent int, mstype int, timeplan int)
 /*
  1       4    1
    11    1    100
    12    4    1000  *
      123 4    10000
      124 1    100000*
    13    4    1000000
     131  1    10000000 *
*/ 
insert @ms select  1 ,  0 ,  4 ,     1 
insert @ms select  11 ,  1 ,  1 ,    100 
insert @ms select  12 ,  1 ,  4 ,    1000 
insert @ms select  123 ,  12 ,  4 ,  10000 
insert @ms select  124 ,  12 ,  1 ,  10000 
insert @ms select  13 ,  1 ,  4 ,    1000000 
insert @ms select  131 ,  13 ,  1 ,  10000000 

declare @id int
set @id= 1 
 -------------------------
 
declare @t table(id int, level int, tp int)
declare @lev int
set @lev= 0 

insert @t 
  select case when mstype <  2  then - 1  else id end, @lev, case when mstype <  2  then timeplan else  0  end
    from @ms
    where id=@id

while exists(select * from @t t, @ms ms where @lev=level and t.id=ms.parent)
  begin
	insert @t 
	  select case when mstype <  2  then - 1  else ms.id end, 
             @lev+ 1 , 
             case when mstype <  2  then timeplan else  0  end
	    from @ms ms, @t t
	    where t.id=ms.parent and level=@lev
    set @lev=@lev+ 1 
  end


select sum(tp) from @t