27,579
社区成员
发帖
与我相关
我的任务
分享
use mydata
declare @items varchar(120)
set @items=(SELECT top 1 C_ChildID
FROM TE08DATA.dbo.TE_CorpInfoReal
where C_FatherID is null)
declare @split varchar(1)
set @split=','
declare @T_Module table(m varchar(6))
while charindex(rtrim(@split),@items) <>0
--print @items
begin
set @items=ltrim(rtrim(@items))
if(substring(@items,1,1) <>@split)
begin
insert into @T_Module (m) values(substring(@items,1,charindex(@split,@items)-1))
set @items =stuff(@items,1,charindex(@split,@items),'')
end
else
begin
set @items=stuff(@items,1,1,'')
end
end
if rtrim(@items) <>''
insert into @T_Module (m) values (@items)
select distinct C_FatherID from TE_Category a,@T_Module b
where a.C_ID=b.m