declare @TT table (level int, ParentID int, ChildID int)
insert into @TT(level,ParentID,ChildID) values( 1,172455, 144461)
insert into @TT(level,ParentID,ChildID) values( 1,172455, 152468)
insert into @TT(level,ParentID,ChildID) values( 1,172455, 210049)
insert into @TT(level,ParentID,ChildID) values( 2,144461, 210049)
insert into @TT(level,ParentID,ChildID) values( 2,144461, 121212)
insert into @TT(level,ParentID,ChildID) values( 2,144461, 158030)
insert into @TT(level,ParentID,ChildID) values( 2,144461, 180465)
insert into @TT(level,ParentID,ChildID) values( 2,152468, 56390)
insert into @TT(level,ParentID,ChildID) values( 2,152468, 215453)
insert into @TT(level,ParentID,ChildID) values( 3,158030, 210049)
insert into @TT(level,ParentID,ChildID) values( 3,180465, 210049)
insert into @TT(level,ParentID,ChildID) values( 3,56390, 210049)
insert into @TT(level,ParentID,ChildID) values( 3,215453, 210049)
;

--select * from @TT;

WITH s ([Level], [ParentID], [ChildID], lvl, hid , [name] ) AS
 (
    SELECT [Level], [ParentID],
     [ChildID] [ChildID],
      0,
      CAST('/'+CAST(ChildID AS VARCHAR(MAX))+'/' AS hierarchyid)
    , 'asdf'  [name] 
     FROM  @TT t
       WHERE  [Level]=1
    UNION ALL
    SELECT t.[Level], t.[ParentID],
    t.[ChildID] [ChildID], 
    s.lvl + 1, 
    CAST(CAST(s.hid AS varchar(MAX)) + CAST(t.ChildID as varchar(MAX)) + '/' as hierarchyid)--, 
    , 'asdf'  [name]       
    FROM @TT  t INNER JOIN s ON s.[ChildID]=t.[ParentID]
)

SELECT [Level], [ParentID], [ChildID],   hid, 
lvl ,replicate('___', lvl)+[name] [name]
  FROM s   ORDER BY  hid 

WITH s ([Level], [ParentID], [ChildID], lvl, hid , [name] ) AS
 (
    SELECT [Level], [ParentID],
     [ChildID] [ChildID],      0,
      CAST('/'+CAST(ChildID AS VARCHAR(MAX))+'/' AS hierarchyid)
    , 'asdf'  [name] 
     FROM  @TT t
       WHERE  ChildID=210049
    UNION ALL
    SELECT t.[Level], t.[ParentID],
    t.[ChildID] [ChildID], 
    s.lvl + 1, 
    CAST(CAST(s.hid AS varchar(MAX)) + CAST(t.ChildID as varchar(MAX)) + '/' as hierarchyid)--, 
    , 'asdf'  [name]       
    FROM @TT  t INNER JOIN s ON t.[ChildID]=s.[ParentID]
    where t.[ChildID]<>t.[ParentID]
)
SELECT [Level], [ParentID], [ChildID],   hid, 
lvl ,replicate('___', lvl)+[name] [name]
  FROM s  ORDER BY  hid