Post reply

Help with SQL algorithm to process transactions

  • June 23, 2009 at 4:22 pm

    #1014337

    Eichpeel (6/23/2009)

    Lutz,

    This looks perfect! I will make sure in the future to try listing all possible scenarios so that the community can test them all. I really love the fact that there is no cursor left. Thank you very much.

    You're very welcome!

    I'm glad it finally worked out without any cursor and any triangular join.;-)

    Just out of curiosity: would you mind posting the performance of your cursor based solution versus the solution you're using now together with some rough figures in terms of data size?


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

  • June 23, 2009 at 4:40 pm

    #1014338

    lmu92 (6/23/2009)

    Lynn Pettis (6/23/2009)

    First of all this:

    UPDATE tablename SET

    @variablename = [i]columnname[/i] = somevalue

    is a documented feature of Microsoft SQL Server. ...

    Hi Lynn,

    would you mind quoting the post you refer to (especially on a thread having two parallel discussions)?

    I've been rechecking my code from my post right above yours in order to figure out what I've done to get a reply like your's until I realized it was the post before mine you referred to... :doze:

    Fixed my post. Sorry. The problem was we were posting so close together. Stupid quote button has been a pain today so I didn't if try it on this post.

Viewing 2 posts - 31 through 31 (of 31 total)

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