Hi Set,

The performance is ok in my tests.

Without "cast(rpad(t3.SortText,10) as varchar(200))" I get trouble on "deeper" 
trees. 

Thanks again for your help.

Still it would be interesting for me wether this can be solved using window 
functions.

Regards,
Josef
  • [firebird-supp... josef.gschwendt...@quattro-soft.de [firebird-support]
    • Re: [fire... Svein Erling Tysvær setys...@gmail.com [firebird-support]
    • Re: [fire... 'livius' liviusliv...@poczta.onet.pl [firebird-support]
      • Re: [... josef.gschwendt...@quattro-soft.de [firebird-support]
    • Re: [fire... setysvar setys...@gmail.com [firebird-support]
      • Re: [... josef.gschwendt...@quattro-soft.de [firebird-support]
        • R... Svein Erling Tysvær setys...@gmail.com [firebird-support]
          • ... josef.gschwendt...@quattro-soft.de [firebird-support]
    • Re: [fire... liviuslivius liviusliv...@poczta.onet.pl [firebird-support]
      • [fire... josef.gschwendt...@quattro-soft.de [firebird-support]

Reply via email to