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) values (, , , , , , , , , ); SELECT fspro_userid = @@IDENTITY update tbl_crm_interactions set contactid = , dispositionDate = getdate() where ownerid = and ownertype = and interactionid =