[HIDE]
[/HIDE]
Kod:
Update [SRO_VT_SHARD].[dbo].[Tab_RefNest]
Set dwMaxTotalCount = dwMaxTotalCount * 0
Where dwTacticsID IN (Select dwTacticsID FROM [SRO_VT_SHARD].[dbo].[Tab_RefTactics]
Where dwObjID IN (SELECT ID FROM SRO_VT_SHARD.dbo._RefObjCommon Where CodeName128 LIKE '%MOB_RM%') )
Jangandaki moblar : select * from _RefObjCommon where CodeName128 like '%MOB_CH%'
Donwhang'daki moblar 1: select * from _RefObjCommon where CodeName128 like '%MOB_WC%'
Donwhang'daki moblar 2: select * from _RefObjCommon where CodeName128 like '%MOB_OA%'
Hotandaki moblar : select * from _RefObjCommon where CodeName128 like '%MOB_KT%'
Karakoramdaki moblar : select * from _RefObjCommon where CodeName128 like '%MOB_KK%'
Taklamakan'daki moblar : select * from _RefObjCommon where CodeName128 like '%MOB_TK%'
Downhang Cave'deki moblar : select * from _RefObjCommon where CodeName128 like '%MOB_DH%'
Roc Mountain'deki moblar : select * from _RefObjCommon where CodeName128 like '%MOB_RM%'
Constantinople'deki moblar : select * from _RefObjCommon where CodeName128 like '%MOB_EU%'
Samarkand'daki moblar 1: select * from _RefObjCommon where CodeName128 like '%MOB_AM%'
Samarkand'daki moblar 2 : select * from _RefObjCommon where CodeName128 like '%MOB_CA%'
Jangan cave'deki moblar : select * from _RefObjCommon where CodeName128 like '%MOB_TQ%'
Alexandria'daki moblar : select * from _RefObjCommon where CodeName128 like '%MOB_SD%'
Jupiter'deki moblar : select * from _RefObjCommon where CodeName128 like '%MOB_JUPITER%'
Forgotten World'deki moblar : select * from _RefObjCommon where CodeName128 like '%MOB_GOD%'
