表T
ID Folder ParentID
1 AA 0
2 BB 1
3 CC 1
4 DD 3
已经知道ID=4
求结果
AA\CC\DD
---------------------------------------------------------------
drop table #T
create table #T
(id int,
folder varchar(5),
parentid int
)
insert into #T values (1,'AA',0)
insert into #T values (2,'BB',1)
insert into #T values (3,'CC',1)
insert into #T values (4,'DD',3)
declare @id int
set @ID=4
declare @path varchar(20)
select @path = folder, @id = parentid from #T where id = @id
while @id > 0
select @path = folder + ''+@path, @id = parentid from #T where id = @id
select @path
AA\CC\DD