i need query edit dwmaxtotalcount with code mobs

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

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?

Quote:

Originally Posted by M@hmoud i need query edit dbo.Tab_RefNest SET dwmaxtotalcount with code mobs

To edit what exactly?

Quote:

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_%'