gengxin0505
- 浏览: 961 次
-
最新评论
文章列表
递归，用于部门的拼接。
eg：
WITH orgs AS (
SELECT o.org_id , o.org_name, o.ORG_PARENT , CAST('/'+ o.ORG_NAME as varchar(4000)) as pname from U_ORG o where o.org_id = 1
union all
SELECT s.ORG_ID , s.ORG_NAME , s.ORG_PARENT , cast(s.ORG_NAME + '/'+b.pname as varchar(4000)) from U_ORG s , orgs b
...