dear celko,

your commend is much to advanced for my knowledge (i am a sql rookie). you're speaking about optimisation? can you give a short example of code which demonstartes what...

hi SSChampion,

sorry for that i've cause inconvenience!

wow, i didn't know that you will solve the whole problem...

thank you very much for the code, i have to analyze and understand it,...

thank you lutz!

as far as i understand your suggestion it won't solve the problem.

in my cte code i finally order convert the former constructed 'myorder'-key into a number type and...

sorry for my bad explenation!

actually if you are looking on the screenshot the segmente_sort - column is the sort-order supposed to be.

that means the sort-order i'm trying to achive...