Home Forums SQL Server 2008 SQL Server Newbies Filtering on multiple input pairs RE: Filtering on multiple input pairs

  • August 18, 2015 at 7:25 am

    #1820712

    Pagan DBA (8/18/2015)

    Thanks guys, but like I said in my original post I already know processing account transaction delta one at a time is slow. Hence this post.

    And, I can look into making things efficient like storing in table and indexing (while I am not seeing how this is appropriate given my input changes on demand for only that set of transactions I need to get deltas for say 5 at a time)

    I will look at link to article from Pinal Dave. However appreciate if someone could answer my last question. Basically, will JOIN as I have stated work? FWIW, I'm using SQL Server 2008.

    Thanks in advance.

    At this point and if it were me, I'd just try it. One test is worth a thousand expert opinions. 😛

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