December 29, 2011 at 11:59 am
nadav (12/28/2011)
As i Mentioned Abovethe goal is to create a so called querit generator.
say there is a standard database for an ERP system (of any sort) that installed on varios customers locations.
I want to be able to uses a VIEW like bulding blocks to create all sort of DATA manipulation reports.
If i use this reports without a detailed SQL code derived from the nested views, i will need to install and create this views in every customer i reach - and i dont want to do that....
instead i would like to have a code that can be use in any installed location no matter the views in it
There are other ways to do this than nested views. What exactly is different about each customer that they need these nested views? Could simple stored procedures handle the report requests? I most often see this sort of nested view tendency when developers want some sort of magic black box type logic engine that gives them everything they want in one fell swoop.
Is there some reason you can't use stored procedures for reports?
Todd Fifield
Viewing post 16 (of 15 total)
You must be logged in to reply to this topic. Login to reply