EXCEL HELL!!!

  • "my "Excel Hell" presentation last night"
    Was that an online presentation?

  • grovelli-262555 - Wednesday, April 12, 2017 8:33 AM

    "my "Excel Hell" presentation last night"
    Was that an online presentation?

    No.  It was in-person at a local PASS chapter.

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

  • Thanks
    "I wrote one in T-SQL and made a "trial" presentation of the technique for my local PASS chapter. I'm converting that to an article."
    Is the article freely available?

  • grovelli-262555 - Thursday, April 13, 2017 9:12 AM

    Thanks
    "I wrote one in T-SQL and made a "trial" presentation of the technique for my local PASS chapter. I'm converting that to an article."
    Is the article freely available?

    I've not yet written the article.  I did find out where they squirreled away the presentation material I included.  Here's the link.
    http://glass.pass.org/Portals/453/Avoid%20Excel%20Hell%20with%20T-SQL.zip

    --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 4 posts - 61 through 63 (of 63 total)

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