Alle Kindeskinder(...) virtueller Ordnerstruktur herausfinden

[Bummi]

Was für eine Datenbank verwendest Du, der SQL-Server z.B. steigt bei 32 Rekusionen aus.
Vielleicht in der Art.

SQL-Code:

Declare @Parent int
Declare @count int
Select @Parent=14

Select cast(ID as Int) as ID
into #tmp
from Tabelle where ParentID=@Parent

select @Count=0
While @Count<(Select Count(*) from #tmp)
   begin
   Select @Count=(Select Count(*) from #tmp)
   insert into #tmp Select Cast(ID as int) from Tabelle where ParentID in (Select ID from #tmp) and ID not in (Select ID from #tmp)
   end
Select * from #tmp
Drop table #tmp