[SQL] Kaskadierende Eltern-Kind Beziehung in selber Tabelle auflösen

[Bummi]

etwas in der Art

SQL-Code:

Select Cast(ID as Int) as ID, Parent, Cast([text]  as Varchar(4000)) as text
into #tmp
from tree --where Parent is  NULL


While Exists(Select * from #tmp join tree on tree.Parent=#tmp.ID)
Update #tmp set text = #tmp.text +' '+ tree.Text  ,#tmp.ID=tree.id 
from tree
where tree.Parent=#tmp.ID


Select * from #tmp
Drop table #tmp