摘要： ; with subDepartment as ( select BesonDepartmentID, DepartmentName, ParentBesonDepartmentID, 1 as HierarchyLevel from dbo.[_Department] where BesonDepartmentID = 1 union all select A.BesonDepartmentID, A.DepartmentName, A.ParentBesonDepartmentID, B.Hierarch... 阅读全文