with teddie as ( select fspro_userId, firstName, lastName, email, ownerId, fsl_tablecode from tbl_Fspro_members where email like 'christine.walker@%' ) select 'MSC' partnerType, ownerId as partnerId, InternalContactID as fseContactId from tbl_PRT_IndustryPartnerLink where InternalContactID in ( select fspro_userId from teddie ) select ownerId, fsl_tablecode from tbl_FSPRO_Members with (nolock) where fspro_userId = select top 1 fspro_userId from tbl_FSPRO_Members with (nolock) where ownerId = and fsl_tablecode = and email = update tbl_FSPRO_Members set email = where fspro_userId = update #_tableName# set InternalContactID = where #_partnerIdCol# = and InternalContactID = delete from tbl_FSPRO_Members where fspro_userId =