select groupID from tbl_SEC_Groups with (nolock) where GroupTypeCD = 'MRR' and ownerid= 0 and FSL_TableCode = 'SYS' and ( groupname = 'Distributor Management' or groupname = 'Operator Selling' ) select distinct tm.teamMemberUserId, m.firstName, m.lastName from tbl_TER_TeamMembers tm with (nolock) inner join tbl_TER_TeamMembers mm with (nolock) on mm.territoryId = tm.territoryId inner join tbl_FSPRO_Members m with (nolock) on m.fspro_userid = tm.teamMemberUserId and m.ownerId = tm.ownerId inner join tbl_SEC_MemGrpLink ml with (nolock) on ml.FSPro_UserID = tm.teamMemberUserId and ml.groupId in ( ) where tm.territoryId in ( ) and tm.ownerId = and tm.ownerType = -- and tm.teamMemberRole = 'TeamMember' order by lastName, firstName select distinct tm.teamMemberUserId, m.firstName, m.lastName from tbl_TER_TeamMembers tm with (nolock) inner join tbl_TER_TeamMembers mm with (nolock) on mm.territoryId = tm.territoryId inner join tbl_FSPRO_Members m with (nolock) on m.fspro_userid = tm.teamMemberUserId and m.ownerId = tm.ownerId where tm.territoryId in ( ) and tm.ownerId = and tm.ownerType = and tm.teamMemberRole in ( 'PrimaryManager', 'SecondaryManager', 'TeamManager' ) order by lastName, firstName select teamMemberRole from qmd_teamMembers where teamMemberUserId = and teamMemberRole like 'MPR:%'