USE [SRO_VT_SHARD] -- #HB declare @CodeName varchar(max) = 'MOB_SD_AKERU' --- Mob code or NPC code here Select nRegionDBID from Tab_RefNest where dwTacticsID in (select dwTacticsID from Tab_RefTactics where dwObjID in (select ID from _RefObjCommon where CodeName128 = @CodeName))