Thanks for the response! I've tried this but I'm still getting a boat load of stored procedures from the 'sys' schema. Is there any way to hide those?

Aggregating data is definitely where we want to go, there's no question about that. So with that in mind, I don't have any doubt that SSAS is where I...

Thanks for all of these suggestions, you've given me quite a bit to chew on. I think I'm going to investigate using SSAS, because I think it is going...