select int.disposition, int.contactid, int.cdrdistributorid, int.interactiondate, int.comment, int.dispositionuserid,
int.participantid, ma.marketingactivityid, ma.marketingactivityname, int.partnerid, int.partnertype,
int.interactionPurposeId
from tbl_crm_interactions int with (nolock)
left outer join tbl_CRM_Participants par with (nolock)
on par.participantid = int.participantid
left outer join tbl_crm_marketingactivities ma with (nolock)
on ma.marketingactivityid = par.marketingactivityid
where int.interactionid =
and int.ownerid =
and int.ownertype =
select sku.skuid, sku.sku, sku.skuDesc as description, isd.disposition, isd.saleqty, isd.comment, sku.packSizeDesc as packsize,
prd.product as prodcode, prd.shortdesc as proddesc, isd.salesubjectid, isd.salesubjecttype,
rtrim(isd.SaleDurationUnit) as SaleDurationUnit, isd.sourceid, isd.sourcetype, isd.cdrdistributorid,
isd.availabledate, isd.competitorId, isd.InteractionDetailID, isd.taskid, isd.taskdescription, isd.taskduedate
from tbl_crm_interactionsaledetails isd with (nolock)
inner join tbl_prd_skus sku with (nolock)
on sku.skuid = isd.salesubjectid
left outer join tbl_prd_products prd with (nolock)
on prd.prodid = sku.prodid
inner join tbl_crm_interactions int with (nolock)
on int.interactionid = isd.interactionid
where isd.interactionid =
and isd.ownerid =
and isd.ownertype =
and isd.salesubjecttype = 'sku'
union
select 0 as skuid, '' as sku, prd.shortdesc as description, isd.disposition, isd.saleqty, isd.comment, '' as packsize,
prd.product as prodcode, prd.shortdesc as proddesc, isd.salesubjectid, isd.salesubjecttype,
rtrim(isd.SaleDurationUnit) as SaleDurationUnit, isd.sourceid, isd.sourcetype, isd.cdrdistributorid,
isd.availabledate, isd.competitorId, isd.InteractionDetailID, isd.taskid, isd.taskdescription, isd.taskduedate
from tbl_crm_interactionsaledetails isd with (nolock)
left outer join tbl_prd_products prd with (nolock)
on prd.prodid = isd.salesubjectid
inner join tbl_crm_interactions int with (nolock)
on int.interactionid = isd.interactionid
where isd.interactionid =
and isd.ownerid =
and isd.ownertype =
and isd.salesubjecttype = 'prd'
select count(*) as ttl
from qryDetails
where ( disposition = 'FU' or disposition = 'TODO' )
select count(*) as ttl
from qryDetails
where disposition = '?'
or disposition = ''
select count(*) as ttl
from qryDetails
where disposition = 'STD'
and salesubjecttype = 'PRD'
select allowFinalizeWithoutProducts
from tbl_CRM_MarketingActivities
where ownerId =
and ownerType =
and allowFinalizeWithoutProducts = 'N'
and marketingActivityId =