select t.territoryId, t.name territoryName, t.primaryManager from tbl_TER_Territories t inner join tbl_TER_TerritoryLevels l on l.levelId = t.levelId and l.zipCodeMapping = 'ALTERNATE' where exists ( select * from tbl_OPR_ClientOperators o where o.territoryId = t.territoryId ) and t.ownerId = and t.fsl_tablecode = order by territoryName select operatorId, companyName, address, city, state, zipCode, mdmId, mdmType from tbl_OPR_ClientOperators where ownerId = and fsltablecode = and territoryId = order by companyName select m.fspro_userid from tbl_TER_Territories ter inner join tbl_Fspro_members m on m.fspro_userid = ter.primaryManager and m.ownerId = ter.ownerId and m.fsl_tablecode = ter.fsl_tablecode where ter.territoryId =

select m.marketingActivityName from tbl_CRM_Participants p inner join tbl_CRM_MarketingActivities m on m.marketingActivityId = p.marketingActivityId where p.operatorId = and p.ownerId = 26 and p.ownertype = 'MFR' order by marketingActivityName

Operator	New Territory	Move
#htmleditformat( companyName )# #htmleditformat( address )# #htmleditformat( city )#, #htmleditformat( state )# #htmleditformat( zipCode )# #mdmType# : #mdmId# FSE: #operatorId# #htmleditformat( marketingActivityName )#	#htmleditformat( qmd_newTerritory.territoryName )# select interactionId from tbl_CRM_interactions where partnertype = 'OPR' and partnerId = and disposition = '?' and ( coalesce( dispositionUserId, 0 ) = or nullif( dispositionUserId, 0 ) is null ) #qmd_interactions.recordCount# Open Calls to: #htmleditformat( qmd_callTerritory.primaryManagerFirst )# #htmleditformat( qmd_callTerritory.primaryManagerLast )#