Home Forums SQL Server 2005 SQL Server 2005 General Discussion INSERT OUTPUT INTO (With an extra column) and SELECT statement RE: INSERT OUTPUT INTO (With an extra column) and SELECT statement

  • March 14, 2011 at 8:29 am

    #1298356

    Yes, You only need to populate TableC with the initial data.

    The query I am attempting will populate the TableA and TableB

    with the data from TableC.

    Just to be clear. I want val1, val2, val3 & entryDate to be

    INSERTed INTO TableA FROM TableC and preferably during the same step,

    take the @@IDENTITY (aka Inserted.ID) from TableA, and the comID

    from TableC, and INSERT those values INTO TableB

    Thanks for the guidance.

    KK