I am currently working on a system where a section of the application (Tasks) uses one Sproc and Consistently built views to generate the Tasks. The idea being that if you use a consistent build for your views and add them to a Lookup table then
the Procedure can iterate through the task views and generate the Tasks for a given person.
My question is around this process. In Oracle I probably would have built a package and then added separate procedures for each of the new views instead of dynamically generating the list. I really like that this process enforces consistency, but
something about it just doesn't feel right (Lookup table and iterating through the views to generate output).
I just wanted to see what the SQL gurus out there thought about this process. I am not pushing a right or wrong just trying to always question the way I am doing things and look for a better method.
Always appreciate the feedback.
View Complete Post