Step 1: #_end-_start# ms select max(interactiondate) as callDate from tbl_CRM_Interactions where PartnerId = and PartnerType in () and Disposition <> '?'
Step 2: #_end-_start# ms select min(interactiondate) as callDate from tbl_CRM_Interactions 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 where ownerid = and ownertype = and StatusCode = 'A' select sum(caseamt) caseTotal, sum(weightamt) weightTotal, count(*) as oppTotal from tbl_SPL_Opportunities spl where spl.OwnerID = and spl.OwnerType = and spl.PartnerID = and spl.PartnerType = and spl.stageid in ()
Step 6: #_end-_start# ms

ALERTS
1	ConAgra opportunity past due.
2	Contract coming due in 15 days.
3	Trade deal alert of some kind.

select sum( volumeQty ) volumeQty from qryPurchProfile select companyname, operatorid from tbl_opr_clientoperators where ownerid = and fsltablecode = and operatorid =


Photo

YTD #_mfrUOM.unitOfMeasurePlural#	#numberformat(qcfAccountDetails.annualqty_TY,"9,999")# #_deltaQty.indicatorCharacter##_deltaQty.deltaPercent#

YTD #ucase(_mfrUOM.altUnitOfMeasureAbreviated)#	#numberformat(qcfAccountDetails.annualalt_TY,"9,999")# #_deltaAlt.indicatorCharacter##_deltaAlt.deltaPercent#

YTD Dollars	$#numberformat(qcfAccountDetails.annualdollars_TY,"9,999")# #_deltaDollars.indicatorCharacter##_deltaDollars.deltaPercent#

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

Territory	#qcfAccountDetails.territoryName#

Acct Num	#qcfAccountDetails.cdr_dstcode#

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

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#

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