select name
from tbl_ter_territories
where ownerid =
and fsl_tablecode =
and territoryid =
select firstname, lastname
from tbl_fspro_members
where fspro_userid =
select orderTypeId, orderTypeDesc
from tbl_pos_ordertypes
where ordertypeid =
_newOrder = false;
_terrId = qmd_getOrderHdr.TerritoryId;
_terrName = qryTerritory.name;
_rqstrUserId = qmd_getOrderHdr.rqstrUserId;
_rqstrUserName = qryRequester.firstname & ' ' & qryRequester.lastname;
_ordTyp = qmd_getOrderHdr.smpl_orderType;
_ordTypId = qmd_getOrderHdr.smpl_orderTypeId;
_orderTypeDesc = qryType.orderTypeDesc;
_orderTypeSysType = trim(qmd_getOrderHdr.orderTypeSysType);
_submitAction = "update";
_smpl_eventId = qmd_getOrderHdr.smpl_eventId;
_ordStatus = qmd_getOrderHdr.status;
_newOrder = true;
_terrId = "";
_terrName = "";
_rqstrUserId = "";
_rqstrUserName = "";
_ordTyp = "";
_ordTypId = "";
_orderTypeDesc = "";
_orderTypeSysType = "";
_submitAction = "insert";
_smpl_eventId = "";
_ordStatus = "";
_disableForm = "false";
SELECT distinct t.TerritoryID, t.Name, t.PrimaryManager, isPrimaryManager = 0, tL.Rank
FROM tbl_TER_Territories t, tbl_TER_TerritoryLevels tL
WHERE t.OwnerID =
AND t.FSL_TableCode =
AND t.TerritoryID IN ()
AND t.LevelID = tL.LevelID
SELECT t.TerritoryID, t.Name, t.PrimaryManager, isPrimaryManager = 0, tL.Rank
FROM tbl_TER_Territories t, tbl_TER_TerritoryLevels tL
WHERE t.OwnerID =
AND t.FSL_TableCode =
AND t.TerritoryID IN ()
AND t.TerritoryID IN ()
AND t.LevelID = tL.LevelID
SELECT distinct TeamMemberUserID, FirstName, LastName
FROM qmd_territoryMembers
ORDER BY LastName, FirstName
SELECT TerritoryID, Name
FROM qmd_getTerritories
ORDER BY isPrimaryManager desc, Rank, Name