select opr.operatorId, opr.mfrcustnum, opr.primaryContactId, m.fspro_userId, m.cajobfunction, opr.setMethod, m.firstName, m.lastName, m.email, m.phone, 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, cls.name clsName, m.cellPhone, m.fax 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.orgId = opr.operatorId and m.orgType = 'OPR' left outer join tbl_OPR_CLassifications cls on cls.classificationId = opr.classificationId 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 = inner join tbl_IMPORT_ClientPartners i on i.partnerId = opr.operatorId and i.recordSource = and i.company_type = order by sortRank, companyName, opr.operatorId

*** Preview *** #_recordSource# - #lsDateFormat( now() )# at #lstimeformat( Now() )# *** Preview ***

Class	Operator	Address	Contact	Segment	Territory
#clsName#	#companyName# #mfrCustNum#	#address# #address2# #city#, #state# #zipcode#	#firstName# #lastName# roleId: #caJobFunction# &##160;&##160;email:#email# &##160;&##160;phone:#phone# &##160;&##160;cell:#cellPhone# &##160;&##160;fax:#fax#	#segDesc#	#setMethod#: #territoryName#Unassigned

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