تقليل عدد الموبس

[MinaThabit]

Use SRO_VT_SHARD -------Mina
-------------------------------------------
Declare @MonsterCodeName Varchar(Max)
--------------------------------------------
set @MonsterCodeName ='MOBCODE'
--------------------------------------------
delete [dbo].[Tab_RefNest] WHERE dwTacticsID in(SELECT [dwTacticsID] FROM [dbo].[Tab_RefTactics] WHERE dwObjID in(select ID from _RefObjCommon where CodeName128=@MonsterCodeName))
--------------------------------------------