select publishDate, unpublishDate, marketingactivityname, marketingactivityid, 99 sortGroup
from tbl_CRM_MarketingActivities ma
where ownerid =
and ownertype =
-- and ( ma.publishdate <= getdate() and ma.unpublishdate >= getdate() )
and ma.crmActive = 'Y'
and ( ma.marketingActivityId in ( select mat.marketingActivityId
from tbl_CRM_MarketingActivityTargets mat
where mat.ownerId=
and mat.ownerType =
and mat.territoryId in ( )
)
or ma.primaryContactUserId =
)
select marketingactivityname, marketingactivityid, sortGroup
from qryMktActivities
order by sortGroup, marketingActivityName
select campaignid, campaignname
from tbl_CRM_campaigns
where ownerid =
and ownertype =
and active = 'y'
order by campaignname
select mac.maCategoryId, mac.ownerId, mac.ownerType, mac.name
from tbl_CRM_MarketingActivityCategories mac
where mac.ownerId =
and mac.ownerType =
order by mac.name
select * from request.qmd_userTerritoryHierarchy
where levelName <> 'Sub-Territory'
select * from qmd_userTerritoryHierarchy
order by displayOrder
select * from qmd_userTerritoryHierarchy
where brokerLevel = 1
select distinct b.broker_id, b.broker_name
from tbl_SMA_BrokerOfficeLink sma
inner join tblBrokers b
on b.broker_id = sma.brokerId
where sma.territoryId in ( )
and sma.mfr_id =
order by broker_name
select distinct rank
from qmd_userTerritoryHierarchy