اصلاح کوئری update
نه سال پیش منتشر شده
تعداد بازدید: 779
کد پروژه: 47190
شرح پروژه
سلام
من این اسکریپت رو در sql اجرا می کنم ارور میده . لطفا اسکریپت صحیحش رو ارسال نمایید
--------------------
update [dbo].[FactInventory]
set LastProfit2= (case when sum([RealSaleAmount]) is NULL then 0 else sum([RealSaleAmount]) end)
-
(((( (case
when sum([SleepInventoryDayCount]) is NULL and sum([FeePurchaseDecreasePurchaseDescent]) is not NULL then sum([FeePurchaseDecreasePurchaseDescent])
when sum([SleepInventoryDayCount])is not NULL and sum([FeePurchaseDecreasePurchaseDescent]) is NULL then sum([SleepInventoryDayCount])
when sum([SleepInventoryDayCount]) is NULL and sum([FeePurchaseDecreasePurchaseDescent]) is NULL then 1
else sum([SleepInventoryDayCount])*sum([FeePurchaseDecreasePurchaseDescent]) end
)
*0.001)
+case when sum([FeePurchaseIncreaseSaleDescent]) is null then 0 else sum([FeePurchaseIncreaseSaleDescent]) end )
-
(case
when sum([Rebait2]) is NULL and sum([PurchaseGoodsUnitFee]) is not NULL then 0
when sum([Rebait2]) is not NULL and sum([PurchaseGoodsUnitFee]) is NULL then sum([Rebait2])
when sum([Rebait2]) is NULL and sum([PurchaseGoodsUnitFee]) is NULL then 0
else sum([Rebait2])*sum([PurchaseGoodsUnitFee]) end
))
*
case when sum([SalesCount]) is NULL then 1 else sum([SalesCount]) end )
----------------
مهارت ها و تخصص های مورد نیاز
مهلت برای انجام
1روز
وضعیت مناقصه
بسته
درباره کارفرما
عضویت شانزده سال پیش
