update tbl_crm_interactionsaledetails set saleConfirmedDate = , saleConfirmedBy = , saleConfirmedContactId = , saleConfirmedFailureReasonId = , saleConfirmedNotes = , saleConfirmed = where ownerId = and ownerType = and interactiondetailid = and interactionId = update tbl_crm_interactions set saleConfirmedDate = , saleConfirmedBy = , saleConfirmedNotifyNote = nullif( , '' ) where interactionid = and ownerId = and ownerType =