Posted by Doug on 12/22/05 21:36

wow. Celko suggesting a totally flattened, junk data model. by far,
this is the worst solution so far. A better solution is to brute force
a temp table and populate it each time you want the report. If you do
it this way, at least your number of columns can be dynamic.

Add an identity field. Trust me, you will like it for hte long term.

On your pivot table, can you use a "min" function as your aggregation?
If so, maybe we can "cheat" the pivot table into diplaying the minimum
color for each identity.

[Back to original message]