无限级递归根据某一级获取拥有值

1.根据某一级获取它所有子级:

代码示例:

create PROCEDURE [dbo].[Oud_FindPlanTypesIDS]

(    

   @TypeID uniqueidentifier

)

 AS

 BEGIN     WITH

SUB_TABLE ( FTypeID , FParentID , FName)     AS    

   (        

  SELECT             FTypeID ,             FParentID ,             FName         FROM O_TeachingPlanTypes         WHERE FTypeID = @TypeID                 UNION ALL

        SELECT             PRIOR_TAB.FTypeID ,             PRIOR_TAB.FParentID ,             PRIOR_TAB.FName         FROM         (             SELECT                 FTypeID ,                 FParentID ,                 FName             FROM O_TeachingPlanTypes         )         PRIOR_TAB ,         SUB_TABLE         WHERE SUB_TABLE.FTypeID = PRIOR_TAB.FParentID     )     SELECT * FROM SUB_TABLE     --SELECT COUNT(1) FROM CustomAddressLists WHERE FCustomGroupId IN (SELECT FCustomGroupId FROM SUB_TABLE)

END

2.根据某