时间：2021-07-01 10:21:17 帮助过：2人阅读
WITH UserID (OrgCode, ParentCode, Level)
AS
(
SELECT OrgCode,ParentCode,0 AS Level
FROM UMS_Organization
WHERE OrgCode= ‘ORG12743‘
UNION ALL
SELECT e.OrgCode,e.ParentCode, Level + 1
FROM UMS_Organization AS e
INNER JOIN UserID AS d
ON e.ParentCode = d.OrgCode
)
SELECT OrgCode FROM UserID
http://www.cnblogs.com/xqhppt/archive/2011/02/15/1955366.html
SQL语句-递归
标签：