Dwain,

I bow before the majesty of your CASE / GROUP BY logic. I couldn't figure out how to do it without a temp table.

As my neighbor would say, "that's slicker 'n' own snot!"