USE Arcadia
GO
UPDATE dbo.MonsterResource
SET taming_percentage=1.0000
WHERE taming_percentage>0.0000
to check if all are done
USE Arcadia
GO
SELECT DISTINCT taming_id,taming_percentage,model
FROM dbo.MonsterResource
WHERE taming_percentage>0.0000
ORDER BY taming_percentage ASC
Its copy/paste =D
|