Hi Naomi
Thanks for replying.
So when you say two 'Virtual' tables, are there two tables created as part of the Output, or two different rows ?
Any good examples around where a MERGE is used to 'Update' data ?
Tia
Gerard


>>Have started to use the Merge command, and now want to use it with Output (For Auditing)
>>I Can see examples of Deleted.* and Inserted.* but cannot see anywhere to capture Modified Columns
>>
>>Anybody got an example (of Output with Merge) where Inserted, deleted AND ALTERED columns are output ?
>>
>>Tia
>>Gerard
>
>New values (modified) are in Inserted and the original values (before the update) are in the Deleted tables.
>
>In other words, SQL Server has only two virtual tables: Deleted and Inserted. In case of UPDATE, Inserted has new values (after update) and Deleted hold values before the update.