select importId, ownerId, ownerType, operatorId, fspro_userid, recordSource, company_id, extendedFld_1, company_name, company_type, opr_class, seg_team_acct, company_phone, company_address1, company_address2, company_city, company_state, company_zip, contact_last_name, contact_first_name, contact_fax, contact_phone, contact_email, company_last_modify_date, contact_last_modify_date, affiliate_nbr, affiliation_type, affiliation_orgNbr from tbl_IMPORT_CLientOperators i where i.recordSource = and i.ownerId = and i.ownerType = and i.extendedFld_1 is null and i.operatorId is null select clientsegid, description from tbl_OPR_ClientSegments where ownerId = and fsl_tablecode = order by sortRank desc select listId from tbl_LST_partnerLists where ownerId = and ownerType = and listName = and listType = 'SYSTEM' and partnerType = 'OPR' SET NOCOUNT OFF INSERT INTO tbl_LST_PartnerLists ( ownerId, ownerType, listName, listType, createdBy, partnerType, locked ) VALUES ( , , , , , , 'Y' ) SELECT listId = @@identity SET NOCOUNT ON select operatorId, companyName from tbl_OPR_ClientOperators where ownerId = and fsltablecode = and crmActive = 'Y' and mfrCustNum = and oprcompanyType =

Affiliate not found for #affiliation_type#:#affiliation_orgNbr#

select clientSegId from qmd_segments where description =

Can't find #company_type# for #company_Name#:#company_id#

set nocount on insert into tbl_OPR_ClientOperators ( ownerId, fsltablecode, companyName, mfrcustnum, address, address2, city, state, zipcode, recordSource, datecreated, lastUpdated, oprSegment, independentYn, oprCompanyType, setmethod ) values ( , , , , , , , , , , {fn now() }, , , , , ) select operatorId = @@identity set nocount off update tbl_OPR_ClientOperators set mfrCustNum = where operatorId = and ownerId = and fsltablecode = set nocount on insert into tbl_FSPro_members ( firstName, lastName, email, phone, officeAddrSame, createDate, lastUpdated, originalSource, orgId, orgType, ownerId, fsl_tablecode ) values( , , , , 1, { fn now() }, , , , , , ) select fspro_userid = @@identity set nocount off update tbl_OPR_ClientOperators set primaryContactId = where operatorId = update tbl_CRM_affiliations set affiliationStatus = 'A', affiliationDate = { fn now() }, sourceId = -1, sourceType = 'SYS' where affiliationId = and partnerAffiliateNbr = and ownerId = and ownerType = insert into tbl_CRM_Affiliations ( ownerId, ownerType, affiliationType, orgId, orgType, affiliationDate, affiliationStatus, partnerId, partnerType, partnerAffiliateNbr, sourceId, sourceType ) values ( , , , , , , , , , , , ) insert into tbl_LST_PartnerListItems (listId, partnerId ) values( , ) update tbl_IMPORT_ClientOperators set operatorId = , fspro_userId = where importId = select distinct division from tbl_TER_TerritoryLevels where brokerLevel = 1 and ownerId = and fsl_tablecode = select firstName, lastName, fspro_userid, orgId, orgType, email, originalSource from tbl_Fspro_members where originalSource = select opr.operatorId, opr.mfrcustnum, opr.primaryContactId, opr.setMethod, m.firstName, m.lastName, m.email, m.phone, opr.operatorId, opr.ownerId, opr.fsltablecode, opr.companyName, opr.address, opr.address2, opr.city, opr.state, opr.zipcode, opr.territoryId, opr.oprsegment, opr.recordSource, opr.datecreated, opr.lastUpdated, opr.crmactive, t.name territoryName, case when t.name is null then 0 else 1 end sortRank, cs.description segDesc from tbl_OPR_CLientOperators opr left outer join tbl_FSPro_members m on m.ownerId = opr.ownerId and m.fsl_tablecode = opr.fsltablecode and m.fspro_userid = opr.primaryContactId and m.orgId = opr.operatorId and m.orgType = 'OPR' left outer join tbl_TER_TErritories t on t.territoryId = opr.territoryId and t.ownerId = opr.ownerId and t.fsl_tablecode = opr.fsltablecode left outer join tbl_OPR_ClientSegments cs on cs.clientSegid = opr.oprsegment inner join tbl_LST_PartnerListItems pli on pli.partnerId = opr.operatorId and pli.listId = order by sortRank, companyName

*** Preview *** #_recordSource# - #lsDateFormat( now() )# at #lstimeformat( Now() )# *** Preview ***
Operator	Address	Contact	Segment	Territory
#companyName# #mfrCustNum#	#address# #address2# #city#, #state# #zipcode#	#firstName# #lastName# #email# #phone#	#segDesc#	#setMethod#: #territoryName#Unassigned

#application.datasource#: #qmd_check.recordCount#(#importCount#) Records Imported

#resultsHTML# #resultsHTML#