Home Forums Article Discussions Article Discussions by Author Discuss content posted by Harsha Majety Temporary Stored Procedures RE: Temporary Stored Procedures

  • June 27, 2013 at 4:32 pm

    #1628158

    Roland Howard Boorman (6/27/2013)

    I wear one cap for Creating, Changing and Updating Data which should be rigorious documented and regulated.

    However businesses need to be flexible over analysis, presentation and using the rich data that they hold to achieve business goals.

    Its this use of data where we findwhat I call hacked code bolted together harded to maintain and poorly documented. Now I developed over the years an approach to this problem using XML , Functions, temporary tables and stored Procs. But in some cases (the example shows an iteration using a temporary proc in a loop ) this will give good documented code that is easy to maintain and yet flexible enough meet changes.

    We need to be aware of the business need, the protection of data and the need to produce well documented code.

    What does any of that have to do with the use TSPs? And, BWAA-HAAA!!!!.... speaking of "well documented code"... what happened to that notion on the code that you provided as an example TSP?

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)