Home Forums SQL Server 2005 Business Intelligence Should I create a VIEW or SP to do this? RE: Should I create a VIEW or SP to do this?

  • July 7, 2011 at 10:02 am

    #1349802

    steveb. (7/7/2011)

    I would go for Option 3, depending on what type of database is used, as this cuts out all the middle work and will be easier to maintain

    While I agree it cuts out the middle man, and that is a good thing, the entire premise is predicated on what drivers are available for the underlying database, provided there actually is one. If it were Postgre, MySQL, DB2, Oracle, and such I might consider this, absent that information I still hold to option 2. My 0.02..

    CEWII