Post reply

Determine if parameter is passed or DEFAULT

  • December 3, 2008 at 4:29 pm

    #907249

    It's a small lake....

    Besides, there's just something so aesthetically satisfying about watching a trebuchet fling (pork chops, tennis balls, cans of vienna sausage, cats, volkswagens, whatever) 😀

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • December 3, 2008 at 6:37 pm

    #907278

    Trebuchet... the ultimate pork chop launcher... can launch the whole pig and makes statements followed by "When pigs fly" come absolutely true. 😛

    --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)

  • December 3, 2008 at 6:41 pm

    #907279

    David Leaver (12/3/2008)

    Yikes - Dip, Dive, Duck and Dodge! Doesn't pay to leave the forums for a few hours.

    Here's the scenario - I'm taking an existing procedure that historically examined each parameter value against a known default, and if different ( and different from the existing record as well), updated a record. If the procedure had 10 params, one being the key, then it would check the other 9 params, and perform an update to the same record for each difference ( I wouldn't claim to have written this if my life was in jeopardy - even at risk of pork chops! ). I think this design was chosen to handle pre/post column level auditing.

    The DAL would only pass in "changed" columns via the interface, so chances are we'd only ever get in 3 or fewer updates per record per request - still unacceptable.

    I'd like to change this to a single update call, with null defaults in order to lower impact on the frontend/DAL.

    So, if I were able to determine that a null value was passed into the procedure vs set as a default value, I could perform the update with a case statement. I can still do with the the default values, was just checking to see if there was an alternative.

    Heh... thanks for having a good sense of humor. 🙂 Just making sure, though... are you all set on this?

    --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)

  • December 4, 2008 at 6:09 am

    #907501

    I'm good - thanks for the info and the chuckle.

Viewing 4 posts - 16 through 18 (of 18 total)

You must be logged in to reply to this topic. Login to reply