Dragan, Thanks.

This is just an "aside" to the main conversation. I am trying to understand your post.

Are you telling me that if my views had no joins and instead I simply pulled each tables data that is needed separately, then using cursors somehow end up with the same data as I was pulling with a view that contained joins, I would be a lot faster?

If that is what you are saying, I understand. In the testing I have done I have noticed, I can pull a million records from a table with no joins in just a few seconds. Add even the simplest join (on indexed fields) and it will almost always, if not always, be many times slower.

All that said, with 1000 views and 80% of those views having at least 1 join, that would seem to be an impossible task.

Thanks for any clarification,
John