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 11, 2011 at 3:29 pm

    #1297914

    Here are the table structures for the example above:

    TableA

    ID int [PK,IDENTITY]

    val1 varchar(10)

    val2 varchar(10)

    val3 varchar(10)

    entryDate datetime

    TableB

    ID int [PK,IDENTITY]

    TableAID int

    comID int

    RelationshipID int

    xPercent varchar(6)

    [status] int

    dateBegin datetime

    TableC

    ID int [PK,IDENTITY]

    val1 varchar(10)

    val2 varchar(10)

    val3 varchar(10)

    entryDate datetime

    comID int

    TIA,

    KK

    "Life is shorter than expected." - Anon.