Step 1: #_end-_start# ms select max(interactiondate) as callDate from tbl_CRM_Interactions with (nolock) where PartnerId = and PartnerType in () and Disposition <> '?'
Step 2: #_end-_start# ms select min(interactiondate) as callDate from tbl_CRM_Interactions with (nolock) where OwnerID = and OwnerType = and PartnerId = and PartnerType in () and Disposition = '?' and interactiondate >
Step 3: #_end-_start# ms
Step 4: #_end-_start# ms select * from qmd_repositoryContents where lower(FileName) like '%.jpg' and lower(docDescription) like '%main account profile photo%' order by UploadDate desc
Step 5: #_end-_start# ms select stageid from tbl_spl_stages with (nolock) where ownerid = and ownertype = and StatusCode = 'A' select sum(caseamt) caseTotal, sum(weightamt) weightTotal, count(*) as oppTotal from tbl_SPL_Opportunities spl with (nolock) where spl.OwnerID = and spl.OwnerType = and spl.PartnerID = and spl.PartnerType = and spl.stageid in ()
Step 6: #_end-_start# ms select sum( volumeQty ) volumeQty from qryPurchProfile select companyname, operatorid, chainHQUnitNotes, territoryid from tbl_opr_clientoperators with (nolock) where ownerid = and fsltablecode = and operatorid =


Photo

Annual #ucase(_mfrUOM.unitOfMeasureAbreviated)#	#numberformat(qryPurchProfileSummary.volumeQty,"9,999")# #_test.deltaPercent##_test.indicatorCharacter#

Territory	#qcfAccountDetails.territoryName#

Acct Mgr Acct Mgr	#qryCustomerManager.FirstName# #qryCustomerManager.LastName# #_acctmgrCompany# unassigned

Priority	Priority	#replace(qcfAccountDetails.oprtype,'*','A+')# Account

Last Call	#dateformat(_lastInteractionDate,"mmm dd, yyyy")# #daysAgoDisplay#

Next Call	#dateformat(_nextInteractionDate,"mmm dd, yyyy")# #daysAgoDisplay#

Chain	Headquarter Location

Chain	Unit Location #qcfAccountDetails.unitNbr# of #qryParent.companyname#	Unit Location #qcfAccountDetails.unitNbr# of #qryParent.companyname#
Chain Notes: #htmlEditFormat(qryParent.chainHQUnitNotes)# more

more"> ","all")> #qmd_posts.postTitle# #_postComment# #qmd_posts.posterFirstName# #qmd_posts.posterLastName# #daysAgoDisplay#
moreless