USE SRO_VT_SHARD Declare @Lvl int = '110' Update _RefSkill SET Service = 0 where ReqCommon_MasteryLevel1 > @Lvl and basic_code like '%SKILL_CH%' or ReqCommon_MasteryLevel1 > @Lvl and basic_code like '%SKILL_EU%'
USE SRO_VT_SHARD Go Select ID From _RefSkill Where Basic_Code Like '%SKILL_CH%' And ReqCommon_MasteryLevel1 > '110' Select ID From _RefSkill Where Basic_Code Like '%SKILL_EU%' And ReqCommon_MasteryLevel1 > '110'