select m.email, m.firstName, m.lastName, m.fspro_userId
from tbl_TER_Territories t with (nolock)
left outer join tbl_FSPro_Members m with (nolock)
on m.FSPro_UserID = t.PrimaryManager
left outer join tbl_TER_Territories pt with (nolock)
on pt.ownerID = t.ownerID
and pt.fsl_tablecode = t.fsl_tablecode
and pt.territoryid = t.parentTerritoryID
where t.OwnerID =
and t.FSL_TableCode =
and t.ParentTerritoryID in(
)
and t.managementRank = 'D'
order by m.Lastname, m.firstName
select M.FSPro_UserID, M.FirstName, M.LastName, M.Organization, m.email
from tbl_FSPro_Members M with (nolock)
inner join tbl_SEC_MemGrpLink L with (nolock)
on L.FSPro_UserID = M.FSPro_UserID
inner join tbl_SEC_Groups G with (nolock)
on G.GroupID = L.GroupID
where G.GroupID = 8561
and G.OwnerID =
and G.FSL_TableCode =
and M.StaffMember = 1
order by M.LastName, M.FirstName
select FSPro_UserID
from tbl_FSPro_Members with (nolock)
where OwnerID =
and FSL_TableCode =
and email in ()
select t.TerritoryID, pt.name as parentTerritoryName, t.Name, t.InternalSalesID, t.managementRank
,m.FirstName, m.LastName, m.fspro_userId
,t.tradeSupportUserId
from tbl_TER_Territories t with (nolock)
left outer join tbl_FSPro_Members m with (nolock)
on m.FSPro_UserID = t.PrimaryManager
left outer join tbl_TER_Territories pt with (nolock)
on pt.ownerID = t.ownerID
and pt.fsl_tablecode = t.fsl_tablecode
and pt.territoryid = t.parentTerritoryID
where t.OwnerID =
and t.FSL_TableCode =
and t.ParentTerritoryID in(
)
order by m.Lastname, m.firstName
select distinct firstName, lastName, fspro_userId
from qmd_getRepsByTerritories
where fspro_userId is not null
order by lastName, firstName
select firstName, lastName
from qmd_getReps
where fspro_userID =