Mark Eckeard (3/26/2013)
Sean - what did you have in mind? What can I do to make it more scalable?
I don't think you can do it totally dynamical, but you may come closer by using crosstab (also known as PIVOT) queries.
Type "crosstab query" in BOL for some examples.
_____________
Code for TallyGenerator