22,300
社区成员




;WITH cte(id,parentid,tagname)AS(
select id,
parentid,
CONVERT(nvarchar(100),tagname) tagname
from tag
where parentid=0
union all
select t.id,
t.parentid,
CONVERT(nvarchar(100),t.tagname+'-'+p.tagname) tagname
from tag as t
join cte as p
on t.parentid=p.id
)
select *,
(select CNName from DataDic where ID=td.DataDicID) CNName
from TagDic td, cte
where cte.id=td.tagid