Sqlserver2000 递归实现

http://www.cnblogs.com/piccolo/articles/362276.html

 

with cte as
(select zwkmzd_tx,zwkmzd_kmbh,zwkmzd_kmmc=cast(zwkmzd_kmmc as varchar(8000)),
zwkmzd_js
from zwkmzd2009 
union all
select b.zwkmzd_tx, b.zwkmzd_kmbh,a.zwkmzd_kmmc+'----'+b.zwkmzd_kmmc,
a.zwkmzd_js
from zwkmzd2009 a,cte b where b.zwkmzd_kmbh like a.zwkmzd_kmbh+'_%'
and a.zwkmzd_js=b.zwkmzd_js-1
)
select * from cte where zwkmzd_js=1

sys_connect_by_path