The one posted by you back in 2007. I wasn't paying attention to the dates when I was looking at this.

My SQL skills are not much past the beginner level although I can usually pick up some concepts quickly. I'm finding that summarization and pivoting are things I'm having problems with.

I'll try playing with your suggestion.

Thanks,