[alieleraky]

هل الكويري دى هتقلل من عدد بعض الموبز الى عندي

DECLARE @RARE FLOAT = 0.75 /*_#2 = 200%, 1 = 100%, 0.5 = 50%*/

UPDATE TRN 
    SET TRN.dwMaxTotalCount *= @RARE
    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%'
AND ROC.Rarity = 0
AND dwDelayTimeMin < 600
AND dwDelayTimeMin != 0
AND dwMaxTotalCount != 1