Home Forums SQL Server 2012 SQL Server 2012 - T-SQL T-Sql Query RE: T-Sql Query

  • May 29, 2014 at 11:22 am

    #1717460

    ramana3327 (5/29/2014)

    Actually I tried with Outer Apply but it increased the execution time. Actually that SP is not taking that much time from SSMS but from the application it is little longer.

    The dev is saying that we can still implement that query by avoiding that joins. I am in a way to find that

    That's all a part of the reason why I'm suggesting that the company get some professional help.

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