>You're right about the nature of the problem, Thomas. And believe me, I tried so many various combinations trying to solve this by Select-SQL that my brain hurt.
>My final conclusion - that's the kind of the problem is hard to solve with select-SQL (unless you want to use UDF or some sort of LOOKUP functions in SQL).
>So I just solved the problem by procedural way.

Which perhaps is better than creating a dynamic SQL - but I wonder about the "schema" of the denormalization (at least to the amount/reason I was visualizing it <g>). But I am notoriously arguing specs...

regards

thomas