Home Forums SQL Server 2008 T-SQL (SS2K8) Best way to insert into two related tables? RE: Best way to insert into two related tables?

  • February 15, 2013 at 3:18 pm

    #1588536

    OTF (2/15/2013)

    You can also take a look at using OUTPUT.

    I've found that to be a wee bit more difficult than you would think unless you have an alternate key to reliably express the new value across the other tables.

    With that thought in mind, do you have a coded example of how to do this?

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