UPDATE dbo.Tab_RefNest SET dwmaxtotalcount=1
like!![]()
UPDATE dbo.Tab_RefNest SET dwmaxtotalcount=1
like!![]()
More like this....
DECLARE @MonsterID INT
DECLARE @Monster varchar(129)
DECLARE @Rate INT
SET @Rate=3
SET @Monster='MOB_CH_MANGNYANG'
SET @MonsterID = (select ID from _RefObjCommon where CodeName128=@Monster)
UPDATE Tab_RefNest
SET dwMaxTotalCount=dwMaxTotalCount*@Rate
FROM Tab_RefNest as n
INNER JOIN Tab_RefTactics AS t
ON n.dwTacticsID = t.dwTacticsID WHERE t.dwObjID=@MonsterID