This is cleaned up. Works great. Thanks for the great script.

Jon

I was just looking at my resultant code and it begged the question: How can I turn this procedure into a view? The challenge as I see it is...

Wow...I know you guys take for granted how easy it is to spit those things out, but I can't imagine what people in my position would do if we didn't...

Taking this to the next level, let's look at textual data instead of numeric. Consider two tables with a one to many relationship. We can even remove the...