select * from request.qmd_userTerritoryHierarchy
where levelName <> 'Sub-Territory'
select * from qmd_userTerritoryHierarchy
order by displayOrder
select distinct e.territoryid
from tbl_EVT_Events e
where e.ownerid =
and e.ownerType =
select * from qmd_userTerritoryHierarchy
where brokerLevel = 1
and territoryid IN ()
order by name
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
select DISTINCT opr.operatorid as partnerid, 'Operator' as partnerType, opr.companyName, sortOrder = 3
from tbl_EVT_Events e
inner join tbl_OPR_ClientOperators opr on e.partnerid = opr.operatorid and e.partnerType = 'OPR'
where e.ownerid =
and e.ownerType =
and opr.operatorid =
and opr.fsltableCode =
union
select DISTINCT cdr.cdr_recordID as partnerid, 'Distributor' as partnerType, cdr.cdr_dstname as companyname, sortOrder = 2
from tbl_EVT_Events e
inner join tbl_CDR_Distributors cdr on e.partnerid = cdr.cdr_recordID and e.partnerType IN ('DST','CDR')
where e.ownerid =
and e.ownerType =
union
select DISTINCT cdr2.cdr_recordID as partnerid, 'Parent Distributor' as partnerType, cdr2.cdr_dstname as companyname, sortOrder = 1
from tbl_EVT_Events e
inner join tbl_CDR_Distributors cdr on e.partnerid = cdr.cdr_recordID and e.partnerType IN ('DST','CDR')
inner join tbl_DST_Distributors dst1 on dst1.dstid = cdr.FSL_dstid
inner join tbl_DST_Distributors dst2 on dst2.dstid = dst1.dstparentco
inner join tbl_CDR_Distributors cdr2 on cdr2.FSL_dstid = dst2.dstid
where e.ownerid =
and e.ownerType =
and cdr.ownerid =
and cdr.fsl_tableCode =
and cdr2.cdr_dstcompanyType = 'P'
and cdr2.ownerid =
and cdr2.fsl_tableCode =
union
select DISTINCT bro.broker_Id as partnerid, 'Broker' as partnerType, bro.broker_name as companyname, sortOrder = 4
from tbl_EVT_Events e
inner join tblBrokers bro on e.partnerid = bro.broker_Id and e.partnerType IN ('BRO')
where e.ownerid =
and e.ownerType =
order by sortOrder, CompanyName
select distinct m.fspro_userid, m.firstname, m.lastname
from tbl_FSPro_Members m
inner join tbl_EVT_Events e on m.fspro_userid = e.salesRepId
where e.ownerid =
and e.ownerType =
order by m.firstname, m.lastname
select eventTypeId, eventType, sortrank
from tbl_EVT_EventTypes
where eventTypeId IN (1,2)
order by eventType
select distinct m.mfr_id, m.mfr_Name
from tblManufacturers m
inner join tbl_EVT_Manufacturers em on m.mfr_id = em.mfrid
inner join tbl_EVT_Events e on em.eventid = e.eventid
where e.ownerType =
and e.ownerid =
order by m.mfr_Name