vSRO - Gold Bug Fix

[ßyMesMes]

Hangi İtemler Al Sat Buguna Dahil ?

USE SRO_VT_SHARD
select RefPackageItemCodeName,Cost,SellPrice from _RefPricePolicyOfItem
inner join _RefObjCommon
on Cost < SellPrice and RefPackageItemCodeName= 'PACKAGE_' + CodeName128
where PaymentDevice = 1

1. Yöntem

use SRO_VT_SHARD
update _RefObjCommon set SellPrice=1 where CodeName128 in(select refitemcodename from _RefScrapOfPackageItem
where RefPackageItemCodeName in(select RefPackageItemCodeName from _RefPricePolicyOfItem where PaymentDevice=1 and Cost=1
)) and SellPrice>1

2. Yöntem

update _RefPricePolicyOfItem set Cost = SellPrice from _RefPricePolicyOfItem
inner join _RefObjCommon
on Cost < SellPrice and RefPackageItemCodeName= 'PACKAGE_' + CodeName128
where PaymentDevice = 1