I was wondering if you had control over the schema and could change it to have all the data broken out into different tables?
Doesn't every DBA/D want control over that? LOL And no, I do not.
Ugly, but it worked with the sample data.
Yeah, but do you think it is possible to do this more "Swan" and less "Duckling?" Is there a better way to start? (other than changing the schema, of course;-))
What is the performance hit of joining the same table 5 times going to be when I try to do 100,000 of these at once?
Thank you for your time and help.