delete from tbl_prt_interactionNotes where noteid = update tbl_prt_interactionNotes set noteText = , dueDate = , reminderDate = , status = where noteid = select ownerid, fsl_tablecode from tbl_prt_industrypartnerlink where IndPrtLnkID = insert into tbl_prt_interactionNotes ( IndPrtLnkID, ownerid, ownertype, submitterid, submittername, notedate, notetext, dueDate, reminderDate, status ) values ( , , , , , , , , , )