SELECT * FROM tbl_TER_TerritoryLevels WHERE OwnerId = AND FSL_TableCode = ORDER BY LevelID SELECT COUNT(*) Cnt FROM tbl_TER_TerritoryLevels WHERE OwnerId = AND FSL_TableCode = INSERT INTO tbl_TER_TerritoryLevels (OwnerId, FSL_TableCode, Name, ParentLevelID, RootLevelID, BrokerLevel, ManagementRole, Division, BusinessPlanReviewCycle, Rank) VALUES (, , , , , , , , , ) SELECT * FROM tbl_TER_TerritoryLevels WHERE OwnerId = AND FSL_TableCode = SELECT Name FROM qmd_TerritoryLevels WHERE LevelId = SELECT Name FROM qmd_TerritoryLevels WHERE LevelId = SELECT LevelId FROM qmd_Destination WHERE Name = '#qmd_LookUpParentName.Name#' SELECT LevelId FROM qmd_Destination WHERE Name = '#qmd_LookUpRootName.Name#' UPDATE tbl_TER_TerritoryLevels SET ParentLevelId = WHERE LevelId = UPDATE tbl_TER_TerritoryLevels SET RootLevelId = WHERE LevelId =