i need query edit dwmaxtotalcount with code mobs

[M@hmoud]

i need query edit dbo.Tab_RefNest SET dwmaxtotalcount with code mobs

[CloudStrife^]

USE SRO_VT_SHARD
UPDATE TRN
SET TRN.dwMaxTotalCount = TRN.dwMaxTotalCount + 1
FROM Tab_RefNest TRN
JOIN Tab_RefTactics TRT ON TRN.dwTacticsID = TRT.dwTacticsID
JOIN _RefObjCommon ROC ON TRT.dwObjID = ROC.ID
WHERE
ROC.CodeName128 LIKE 'MOB_%'


you mean like this?

[Emerald Garden SRO]

Originally Posted by M@hmoud

i need query edit dbo.Tab_RefNest SET dwmaxtotalcount with code mobs

To edit what exactly?

[M@hmoud]

Originally Posted by CloudStrife^

USE SRO_VT_SHARD
UPDATE TRN
SET TRN.dwMaxTotalCount = TRN.dwMaxTotalCount + 1
FROM Tab_RefNest TRN
JOIN Tab_RefTactics TRT ON TRN.dwTacticsID = TRT.dwTacticsID
JOIN _RefObjCommon ROC ON TRT.dwObjID = ROC.ID
WHERE
ROC.CodeName128 LIKE 'MOB_%'


you mean like this?

thx bro for help

this code change max to 1 not + or -

USE SRO_VT_SHARD
UPDATE TRN
SET TRN.dwMaxTotalCount = 1
FROM Tab_RefNest TRN
JOIN Tab_RefTactics TRT ON TRN.dwTacticsID = TRT.dwTacticsID
JOIN _RefObjCommon ROC ON TRT.dwObjID = ROC.ID
WHERE
ROC.CodeName128 LIKE 'MOB_%'