USE [SRO_VT_SHARD]
GO
--remove drop eu
UPDATE dbo._RefDropItemAssign
SET DropCount = 0
WHERE RefItemID BETWEEN 14181 AND 14869
UPDATE dbo._RefDropItemAssign
SET DropCount = 0
WHERE RefItemID BETWEEN 12844 AND 14180
UPDATE dbo._RefDropItemAssign
SET DropCount = 0
WHERE RefItemID BETWEEN 11417 AND 12843
UPDATE dbo._RefDropItemAssign
SET DropCount = 0
WHERE RefItemID BETWEEN 10897 AND 11416
UPDATE dbo._RefDropItemAssign
SET Prob_Absolute = 0
WHERE RefItemID BETWEEN 14181 AND 14869
UPDATE dbo._RefDropItemAssign
SET Prob_Absolute = 0
WHERE RefItemID BETWEEN 12844 AND 14180
UPDATE dbo._RefDropItemAssign
SET Prob_Absolute = 0
WHERE RefItemID BETWEEN 11417 AND 12843
UPDATE dbo._RefDropItemAssign
SET Prob_Absolute = 0
WHERE RefItemID BETWEEN 10897 AND 11416
UPDATE dbo._RefDropItemAssign
SET Prob_Relative = 0
WHERE RefItemID BETWEEN 14181 AND 14869
UPDATE dbo._RefDropItemAssign
SET Prob_Relative = 0
WHERE RefItemID BETWEEN 12844 AND 14180
UPDATE dbo._RefDropItemAssign
SET Prob_Relative = 0
WHERE RefItemID BETWEEN 11417 AND 12843
UPDATE dbo._RefDropItemAssign
SET Prob_Relative = 0
WHERE RefItemID BETWEEN 10897 AND 11416