Home Forums SQL Server 2005 SQL Server 2005 General Discussion Nested Transactions - Best Practice RE: Nested Transactions - Best Practice

  • November 12, 2008 at 5:47 pm

    #897851

    Adam, thanks for not only the explanation of what your trigger does and why DRI isn't going to do it for you, but also the trick you came up with for solving your problem. It's gonna useful for a lot of folks, especially me. Thanks again.

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