SQL gets the implementation of all superiors, and SQL gets the implementation of superiors

SQL gets the implementation of all superiors, and SQL gets the implementation of superiors

SQL to obtain the implementation of all superiors

Note:

(1) You can create a function and call it directly;

(2) M0Org is a database table. M0OrgPID is the target table, OrgID is the ID field, and PID is the parent ID field.

DECLARE @ OrgID NVARCHAR (36) = '1970-0000-0000-00000002205223459 '; -- get all superiors of the current organization and put them in M0OrgPID WITH M0OrgPID AS (SELECT *, 0 AS lvl FROM M0Org WHERE OrgID = @ OrgID union all select d. *, lvl + 1 FROM M0OrgPID c inner join M0Org d ON c. PID = d. orgID) SELECT * FROM M0OrgPID;

Thank you for reading this article. I hope it will help you. Thank you for your support for this site!