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