sqlserver 书查询 之二

WITH treeAS(SELECT ParentId,Organization_ID,1 AS x2level,Organization_Name,CAST(Organization_Name AS NVARCHAR(max)) x2name,CAST(+Organization_ID AS NVARCHAR(max)) x2idFROM base_organizationWHERE ParentId=‘0‘UNION ALLSELECT c.ParentId,c.Organization_ID,tree.x2level + 1,c.Organization_Name,CAST(REPLICATE(‘-‘,x2level * 4) + c.Organization_Name AS NVARCHAR(max)) x2name,tree.x2id +‘:|:‘+ CAST(c.Organization_ID AS NVARCHAR(max)) x2idFROM dbo.base_organization cINNER JOIN treeON c.ParentId = tree.Organization_ID)SELECT x2name,ParentId,x2level FROM treeORDER BY x2id;

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!