每日点滴之贰零零玖年玖月壹拾壹日

今天最大的成功就是完成了SQL多级递归的查询，自下而上取得多层组织架构负责人，代码如下：

WITH oo(oid,name,parentid,mid,llevel)

AS

(

    SELECT OID,OName,ParentID,ManagerId,0 llevel FROM t_d_Org

        WHERE OID='B5B5F598-AD37-444A-B78A-07EAC8F773BA'

        UNION ALL

        SELECT l.OID,l.OName,l.ParentID,l.ManagerId,llevel+1 FROM t_d_Org l

            INNER JOIN oo p ON l.OID=p.parentid

)

select * from user

where userid in (SELECT top 10 mid FROM oo order by llevel)

MARK 一记！