USE [SRO_VT_SHARD] GO UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 LIKE '%14_A_RARE%' UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 LIKE '%14_B_RARE%' UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 LIKE '%14_C_RARE%' UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 LIKE '%14_HA_A_RARE%' UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 LIKE '%14_HA_B_RARE%' UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 LIKE '%14_HA_C_RARE%' UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 LIKE '%14_FA_A_RARE%' UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 LIKE '%14_FA_B_RARE%' UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 LIKE '%14_FA_C_RARE%' UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 LIKE '%14_LA_A_RARE%' UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 LIKE '%14_LA_B_RARE%' UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 LIKE '%14_LA_C_RARE%' UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 LIKE '%14_SA_A_RARE%' UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 LIKE '%14_SA_B_RARE%' UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 LIKE '%14_SA_C_RARE%' UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 LIKE '%14_BA_A_RARE%' UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 LIKE '%14_BA_B_RARE%' UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 LIKE '%14_BA_C_RARE%' UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 LIKE '%14_AA_A_RARE%' UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 LIKE '%14_AA_B_RARE%' UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 LIKE '%14_AA_C_RARE%'