UPDATE dbo.Items SET Items.iqtyonhand = Items.iqtyonhand + Deleted.trn_qty - Inserted.trn_qty FROM dbo.Items INNER JOIN Inserted ON Items.iItemid = Inserted.trn_itmfk INNER JOIN Deleted ON Items.iItemID = Deleted.trn_itmfk WHERE iItemTypId = '43'