Post reply

do you have a StripNonNumeric ITVF function?

  • August 29, 2017 at 5:36 pm

    #1957340

    Ah... scratch my previous...  Even though it will likely never be needed, I add ORDER BY to physical Tally table implementations because, as Paul White said over on SE, the ORDER BYs are  "no cost" operations, in this case, that provide a guarantee and, therefor, piece of mind and bullet proofing against MS upgrades (well, unless they mess with ORDER BY again 😉 ).  The same holds true for these types of cCTEs that are used to generate a sequence.... no cost/high peace of mind/bullet proof.

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

Viewing post 46 (of 45 total)

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