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