sqlserver 树结构递归

不净之心

于 2012-05-18 13:49:12 发布

阅读量97

点赞数

CC 4.0 BY-SA版权

文章标签：数据库

本文链接：https://blog.youkuaiyun.com/pyzheng/article/details/84219992

--获取当前及以下部门
Create proc GetCurrentAndUnderOrg
@orgId int
as
begin
    WITH cte 
    AS
    (
        SELECT * ,0 AS level FROM Static_Organ  WHERE OrganID=@orgId
        UNION ALL
        SELECT g.*,level+1 FROM Static_Organ g INNER JOIN cte 
             ON g.ParentOrgan=cte.OrganID
    )
    SELECT * FROM cte
end