Create Table tb_Board
(
  Num   Bigint Identity(1,1)   Primary Key ,
  BType  Varchar(10)       ,
  Title  Varchar(500)       ,
  Content  Text         ,
  Ip   varchar(15)       ,
  Parent  Bigint        ,
  WriteId  varchar(20)       ,
  WriteDate Smalldatetime      ,
  ModfiyID  varchar(20)       , 
  ModfiyDate Smalldatetime      ,
  ViewCount int
)

;with c_tblx as (
 select 0 as emplevel
    ,*
      , convert(varchar(100), ' / ' +cast(Parent as varchar(100)))
        path_order -- siblings by
   from tb_Board
  where Parent = 1  -- start with
  union all
 select emplevel + 1
      ,a.*
      , convert(varchar(100), b.path_order + ' / ' + cast(a.Parent as varchar(100))) 
        -- siblings by
   from tb_Board a
   join c_tblx b
     on a.Parent = b.num -- connect by prior
 )
 select replicate('  ', emplevel * 2) + cast(Parent as varchar(100))
      , *
   from c_tblx

CTE 한 행에서 전체 건수와 현재 ROW 알고 싶은데...

CTE 결과를 임시테이블에 Insert 후

해당테이블에서 Row_Number를 Update해서 확인하시면 될듯하네요..