select ma.marketingActivityId, ma.marketingActivityName, i.interactionDate
from tbl_CRM_interactions i with (nolock)
inner join tbl_CRM_Participants p with (nolock)
on p.participantId = i.participantId
and p.ownerId = i.ownerId
and p.ownerType = i.ownerType
and p.createdInteractionId = i.interactionId
inner join tbl_CRM_MarketingActivities ma with (nolock)
on ma.marketingActivityId = p.marketingActivityId
and ma.ownerId = p.ownerId
and ma.ownerType = p.ownerType
and ma.publishDate <=
and ma.crmActive = 'Y'
where i.disposition = '?'
and i.ownerId =
and i.ownerType =
and i.dispositionUserId =
select marketingActivityId, marketingActivityName, count(*) interactionCount
from qmd_salesCallStatus
group by marketingActivityName, marketingActivityId
order by marketingActivityname