• Couple of things incorrect with the OUTPUT example. There is no 'Oxford' store to update in dbo.tblStore and the SELECT * FROM dbo.StoreAudit should show the InsertedStore as 'Grantham'.