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


Photo

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

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

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

Territory	#qcfAccountDetails.territoryName#

Acct Mgr	#qcf_acctAdditionalInfo.firstname# #qcf_acctAdditionalInfo.lastname# #_acctmgrCompany# unassigned

Acct Num	#qcfAccountDetails.cdr_dstcode#

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

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

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

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

Addl Profile Info #htmleditformat(qcfAccountDetails.comments)#