Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Can we delay the execution?Or ReWrite this Query? RE: Can we delay the execution?Or ReWrite this Query?

  • January 29, 2016 at 7:12 pm

    #1855432

    suryahanuma (1/29/2016)

    I am 100% sure it would not go beyond C usually,with 3 exemptions if all are utilized it will go F. SO we do not have to think until Z.

    The real problem is that the data is denormalized. The letter should be stored in a different column so that you'll be able to do other analysis you don't yet know about without having to write slow moving totally non-SARGable queries.

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