Sorry for the delay on getting back to you.

First of all thanks for your replies. They were really helpful.

The approach suggested by Noeld is the most performant.

We did a...

Thanks Matt. So what you are saying is that the perf of this query as it is cannot be improved unless we move to something like PIVOT?

Thanks

Matias