Need query to change item price
 

need query to change item price for

حضرتك اول طلب هتروح Refpriceofitem
ودور علي الكود اللي عايز تغير سعرو واعمل Paymnetdevice

1 = Gold
2 = Silk
4 = Gift Silk (Received Silk)
16 = Point (vSRO); Premium Silk (iSRO & kSRO)
32 = Honor Point
64 = Copper Coin
128 = Iron Coin
256 = Silver Coin
512 = Gold Coin
1024 = Arena Coin
2-
دلوقتى دخلت الجيم ملئتش البرميم مش موجود
go refobjcommon
ودور علي كود البريميم واعمل ال service 1 مش 0

انا عارف الطريقه دى يا باشا و تسلم على تعبك
بس مفيش كويرى اسهل ؟
علشان بدوخ عقبال ما بجيب الايتم

اتفضل
UPDATE [dbo].[_RefPricePolicyOfItem]
SET Cost = 50000000
WHERE RefPackageItemCodeName like '%PACKAGE_ITEM_CH_M_HEAVY_13_HA_A_RARE%%'
UPDATE [dbo].[_RefPricePolicyOfItem]
SET Cost = 50000000
WHERE RefPackageItemCodeName like '%PACKAGE_ITEM_CH_M_HEAVY_13_SA_A_RARE%%'
UPDATE [dbo].[_RefPricePolicyOfItem]
SET Cost = 50000000
WHERE RefPackageItemCodeName like '%PACKAGE_ITEM_CH_M_HEAVY_13_BA_A_RARE%%'
UPDATE [dbo].[_RefPricePolicyOfItem]
SET Cost = 50000000
WHERE RefPackageItemCodeName like '%PACKAGE_ITEM_CH_M_HEAVY_13_LA_A_RARE%%'
UPDATE [dbo].[_RefPricePolicyOfItem]
SET Cost = 50000000
WHERE RefPackageItemCodeName like '%PACKAGE_ITEM_CH_M_HEAVY_13_AA_A_RARE%%'
UPDATE [dbo].[_RefPricePolicyOfItem]
SET Cost = 50000000
WHERE RefPackageItemCodeName like '%PACKAGE_ITEM_CH_M_HEAVY_13_FA_A_RARE%%'

##