update tbl_OPR_ClientOperators set ownerId = , lastUpdatedBy = 783806 where ownerId = and fsltablecode = and crmActive = 'N' Execution to delete inactive operators did not succeed due to: #cfcatch.message# update mem set ownerId = , lastUpdatedBy = 783806 from tbl_FSPRO_Members mem left outer join tbl_OPR_ClientOperators opr on mem.orgId = opr.operatorId and mem.orgType = 'OPR' where mem.ownerId = and mem.fsl_tablecode = and mem.staffMember = 0 and ( nullif( opr.operatorId, 0 ) is null or opr.crmActive = 'N' ) and mem.fspro_userId not in ( select fspro_userId from tbl_FSPRO_Members mem2 with (nolock) where ownerId = and fsl_tablecode = and ( email like '%@fslibrary.com' or email like '%@fsenablers.com' ) ) Execution to delete contacts did not succeed due to: