/*----------------------------------------------标题：SQL2005 BOM递归迭代方法整理（以公司组织架构为例）整理人：htl258(Tony)日期:2009.04.25(引用请保留此信......
;WITH t AS
(
SELECT *,0 as lvl /*展开层次*/ FROM @t WHERE Supervisor ='Cici'
UNION ALL
SELECT a.*,b.lvl 1 FROM @t a /*原表*/ JOIN t b /*CTE*/ ON a.ParentDept = b.FullDept /*原表父项等于CTE子项
6/10 首页 上一页 4 5 6 7 8 9 下一页 尾页 |
