SQL 层级数据查询出树形状态

WITH TEST AS
(
SELECT  DEPTID,PARENTDEPT,SORTORDER,1 SPAC,CONVERT(CHAR(200),RTRIM(DEPTID)+CONVERT(CHAR(5),ROW_NUMBER() OVER(ORDER BY  SORTORDER))) SORTID  FROM FSe7en_Org_DeptStruct WHERE DEPTID='dep00000' --ORDER BY SORTORDERSELECT  DEPTID,PARENTDEPT,SOR