Interesting Datenames

  • Jason A. Long - Wednesday, November 15, 2017 4:33 PM

    It's the same reason the Flash Gordon theme song pops into my head any time I see a Celko post...

    great... now that correlation is stuck in my head too!  it's spreading!

  • Chris Harshman - Wednesday, November 15, 2017 7:03 PM

    Jason A. Long - Wednesday, November 15, 2017 4:33 PM

    It's the same reason the Flash Gordon theme song pops into my head any time I see a Celko post...

    great... now that correlation is stuck in my head too!  it's spreading!

    You'r welcome! 😀

  • Jason A. Long - Wednesday, November 15, 2017 4:33 PM

    Jeff Moden - Wednesday, November 15, 2017 3:20 PM

    Heh... understood. 😉

    Sorry... I never really matured, mentally, beyond the average 15 year old... It couldn't be helped...

    When I wrote it, I wondered if anyone would understand the implication. 😉  Glad someone caught it.

    --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)
    Intro to Tally Tables and Functions

  • Flash a-ah
    He'll save every one of us

  • Steve Jones - SSC Editor - Thursday, November 16, 2017 8:26 AM

    Flash a-ah
    He'll save every one of us

    Yup... That's the one... Every single time...

  • Nice question, with correct answer. 

    Pity about the explanation, where the statement about delay to the end of the batch is pure nonsense.   There's no delay, it operates imediately;  all future conversions between string and data or vice versa will use the new language, not the old one.  What doesn't happen is that all existing date variables are by magic changed to be different dates, and that (fortunately) doesn't happen at the end of the batch either, since values in databases can be changed only by commiting update or merge statements and values in variables are only modified by set variable statements.

    Tom

Viewing 6 posts - 31 through 36 (of 36 total)

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