Paylaşım Hangi İtemler Al Sat Buguna Dahil ? (1 Viewer)

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

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

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