@ Joe Celko:

Thank you for your post as well. It's not a huge table, but can take awhile to process especially when calls from the web are involved. I'm more of a .Net Programmer and got forced into SQL Duty. We are actually going to balance showing real time data vs showing pre compiled data. I'll definitely use something very similar to what you suggest for our real time data.

Thanks for your reply as well. This community is top notch.