我现在递归查询出来了所有的节点,但是我想让他们在一排显示,1级对应2级三级在一行显示,请问有办法吗,谢谢
上面的结果想显示出来的结果是:
实用工具-易ERP流程实例统计
实用工具-易ERP业务单据统计
WITH cte
AS ( SELECT NodeID ,
ParentID ,
Text
FROM dbo.T_MGT_SapMenuItem
WHERE ParentID = 'ZJ_T'
AND DeleteFlag = 0
UNION ALL
SELECT g1.NodeID ,
g1.ParentID ,
g1.Text
FROM dbo.T_MGT_SapMenuItem g1
INNER JOIN cte ON g1.ParentID = cte.NodeID
WHERE g1.DeleteFlag = 0
)
SELECT * FROM cte