SqlServer查找上级

 --查询树状结构某节点(44)的上级所有根节点     
 with cte_parent(UserId,UserName,ReferralUserId,Level)     
 as    (       
  --起始条件       
  select UserId,UserName,ReferralUserId,0 as Level     
  from aspnet_Members      
  where UserId = 103 
  
  --列出子节点查询条件      
  union all      --递归条件  
  select a.UserId,a.UserName,a.ReferralUserId,b.Level+1 
  
  from aspnet_Members a 
  
  inner join 
  
  cte_parent b     --执行递归，这里就要理解下了  
  
  on a.UserId=b.ReferralUserId
  
)           
select * from cte_parent;