---> update tbl_OPR_ClientOperators set mfr_bsr_id = 0 where ownerId = and fsltablecode = and operatorId = and crmActive = 'N' update tbl_OPR_ClientOperators set crmActive = 'Y' where ownerId = and fsltablecode = and operatorId = select ownerId, fsltablecode, operatorId, recordSource, companyName, address, address2, city, state, zipcode, mfr_bsr_id, territoryId from tbl_OPR_CLientOperators with (nolock) where ownerId = and fsltablecode = and operatorId = update tbl_OPR_ClientOperators set primaryContactId = where operatorId = and ownerId = and fsltablecode = insert into tbl_CRM_PartnerURLs (ownerId, ownerType, partnerId, partnerType, urlType, urlValue) values ( , , , 'OPR', , ) update tbl_OPR_DistributionDetails set accountNumber = where ownerId = and ownerType = and cdr_recordId = and operatorId = insert into tbl_OPR_DistributionDetails ( ownerId, ownerType, operatorId, cdr_recordId, accountNumber ) values ( , , , , ) select l.brokerLevel from tbl_TER_Territories t with (nolock) inner join tbl_TER_TerritoryLevels l with (nolock) on l.ownerId = t.ownerId and l.fsl_tablecode = t.fsl_tablecode and l.levelId = t.levelId where t.ownerId = and t.fsl_tablecode = and t.territoryId = select cho_type from tbl_CHO_Operators with (nolock) where cho_id = #val( _addOperator.fsl_choId )# update tbl_MFR_TPF_PartnerUnitForecast set unit_qty = where forecast_year = and ownerId = and ownerType = and partnerId = and partnerType = insert into tbl_MFR_TPF_PartnerUnitForecast ( ownerId, ownerType, partnerId, partnerType, forecast_year, unit_qty ) values ( , , , , , ) update tbl_OPR_ClientOperators set num_units_lastYr = , num_units_thisYr = , num_units_nextYr = where operatorId = and ownerId = and fsltablecode =