DECLARE @dt1 Datetime= DECLARE @dt2 Datetime= ;WITH ctedaterange AS (SELECT [periodDate]=@dt1 UNION ALL SELECT [periodDate] + 1 FROM ctedaterange WHERE [periodDate] + 1<= @dt2) SELECT [periodDate] FROM ctedaterange OPTION (maxrecursion 0) select 'CALL' as itemType, 'Sales Call' as itemTypeDescription, interactionid as itemId, companyName, '' as itemDescription, cast(interactionDate as date) as itemDate, partnerId, partnerType, cityState, salesRepFirst, salesRepLast, disposition from qrySalesCalls union select 'EVENT' as itemType, eventType as itemTypeDescription, eventId as itemId, companyName, eventName as itemDescription, cast(eventStartDate as date) as itemDate, partnerId, partnerType, '' as cityState, '' as salesRepFirst, '' as salesRepLast, '' as disposition from qryEvents where upper(companyName) like or upper(eventName) like or upper(eventType) like union select 'FILLER' as itemType, '' as itemTypeDescription, 0 as itemId, 'zzz' as companyName, '' as itemDescription, cast(periodDate as date) as itemDate, 0 as partnerId, '' as partnerType, '' as cityState, '' as salesRepFirst, '' as salesRepLast, '' as disposition from qryAllDays order by itemDate, companyName --->

  • #numberformat(_totalOriginalRecords,"9,999")# Items
    • #_rowContent# #_rowContent#
    Week #_week#
    #htmlEditFormat(companyName)#
    #cityState#
    Call: openfinalized  #salesreplast#     		#htmlEditFormat(companyName)# - #htmlEditFormat(itemDescription)#
    #replacenocase(itemTypeDescription,"Distributor","Dist")#
    #month(itemDate)#/#day(itemDate)#
    #ucase(dateformat(itemDate,"ddd"))#