select partnerid, partnertype from tbl_crm_interactions where ownerid = and ownertype = and interactionid = insert into tbl_fspro_members (ownerid, fsl_tablecode, orgid, orgtype, firstname, lastname, title, email, phone, originalsource, cajobfunction, emailYesNo, contactDecisionMaker) values (, , , , , , , , , , , , ); SELECT fspro_userid = @@IDENTITY update tbl_opr_clientoperators set primarycontactid = where ownerid = and fsltablecode = and operatorid = update tbl_opr_clientoperators set primarycontactid = 0 where ownerid = and fsltablecode = and operatorid = and primarycontactid = update tbl_cdr_distributors set primarycontactid = where ownerid = and fsl_tablecode = and cdr_recordid = update tbl_cdr_distributors set primarycontactid = 0 where ownerid = and fsl_tablecode = and cdr_recordid = and primarycontactid = update tbl_crm_interactions set interactionDate = , reminderDays = , contactid = , mileage = , notes = , interactionPurposeId = , thankYouSent = , dispositionDate = getdate() , interactionMethod = where ownerid = and ownertype = and interactionid =