• Ok, adding the deleted in front of that column makes it work. I am getting the records into the tables as needed. It is also entering 10 rows of 'NULL' in every column along with the 7 rows of deleted.

    10 rows happens to be the number of records that the merge statement inserts . I tried to get some data for the inserted records by adding to the statement. I received 'Column name or number of supplied values does not match table definition.'

    Delete

    OUTPUT

    DELETED.OID,

    DELETED.Version,

    DELETED.QK,

    DELETED.GD,

    DELETED.Geometry

    INSERTED.OID,

    INSERTED.Version,

    INSERTED.QK,

    INSERTED.GD,

    INSERTED.Geometry

    GETDATE()

    into table1

    It would not hurt to have the inserted values added to the tables.