Post reply

The Lesser Used Functions

  • January 10, 2025 at 12:00 am

    #4503308

    Comments posted to this topic are about the item The Lesser Used Functions

  • January 10, 2025 at 2:26 am

    #4513011

    I use IIF a whole lot to replace the longer CASE expression in CROSSTABs.  It just makes for shorter code when there are only Yes/No conditions.

    I have used some of the Bit-wise functions but only because someone else decided to store more than 64 conditions in a single column.  That's horrible for doing searches.  An EAV table might work better but that's awefully verbose, comparatively speaking.

    I tested CHOOSE... it's slower than other methods.

    I've not had the need to use TRANSLATE.  It did do some minor testing with it just to make sure that it was behaving in the way I thought it would.

    CONCAT_WS and TRIM were big winners from 2017 along with WITHIN GROUP for STRING_AGG and CSV file types for BULK INSERT (FINALLY!!!)

    The real key is that, except for IIF (which came out long ago), I don't use any of the new functionality that came with 2022 because we had to change to the 1027 compatibility level because the massive performance hits caused 2022 killed us.  The stuff that came out in 2017 was a big help though.

    --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 2 posts - 1 through 1 (of 1 total)

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