create table #(F_item char(10) null ,item char(10) null ,item_name char(10) null )
create table #1(F_item char(10) null ,item char(10) null ,item_name char(10) null ,iev int char(10) null, id )
declare @iev int (树的级数),@id int (第一级的个数)
set @iD =1
找出所有的第一级 '''用游标'''
set @iev =1
insert into #
select * from table where F_item =1while exists(select * from #)
begin
insert into #1
select *,@iev ,@iD
from #
truncate table #
insert into #
select a.*
from tbale a ,#1
where iev=@iev ,id=@iD and a.F_item=item
set @iev =@iev +1
end
SET @iD=@ID+1
create table #1(F_item char(10) null ,item char(10) null ,item_name char(10) null ,iev int char(10) null, id )
declare @iev int (树的级数),@id int (第一级的个数)
set @iD =1
找出所有的第一级 '''用游标'''
set @iev =1
insert into #
select * from table where F_item =1while exists(select * from #)
begin
insert into #1
select *,@iev ,@iD
from #
truncate table #
insert into #
select a.*
from tbale a ,#1
where iev=@iev ,id=@iD and a.F_item=item
set @iev =@iev +1
end
SET @iD=@ID+1
create table #1(F_item char(10) null ,item char(10) null ,item_name char(10) null ,iev int char(10) null, id )
declare @iev int (树的级数),@id int (第一级的个数)
set @iD =1
set @iev =1
insert into #
select * from table where F_item =1
while exists(select * from #)
begin
insert into #1
select *,@iev ,@iD
from #
truncate table #
insert into #
select a.*
from tbale a ,#1
where iev=@iev ,id=@iD and a.F_item=#1.item
set @iev =@iev +1
end以上是找第一机为1的所有
依次类推,采用游标,每次ID+1
最后排序即可(id,iev)