• Thanks Luis! I have to practice and read carefully as CTE is rather confusing for me ;)... but you think this will solve the problem?

    Performance is not the point as in the client table will not be more than 1000 rows.

    Thanks!

    Sue

    Susanne