Post reply

Merry Christmas 2014

  • January 12, 2015 at 5:01 pm

    #1769680

    TomThomson (12/29/2014)

    Iwas Bornready (12/29/2014)

    I would never do it this way.

    I would.

    It's much more fun than messing about with strings as Hugo suggests, because it provides useful mental excercise; but of course I'm no longer responsible for any production SQL code, so I can get away with it - - half a dozen years ago I would have regarded as criminal obfuscation. 😛

    Heh... it's ironic that you used two dashes in your explanation because that will make it so no obfuscation is present.

    SELECT correctformulahere --Calculate Christmas of Current Year

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

  • June 11, 2015 at 1:15 am

    #1804583

    A lot of points for such an easy question

  • July 8, 2015 at 5:57 am

    #1810905

    we don't understand the explanation.can u elaborate more

Viewing 3 posts - 16 through 17 (of 17 total)

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