update @Table
set [Order Load]=CONVERT(INT,[Sell In])+CONVERT(INT,[BackLog]),WOS=case when [ST Weekly Average]=0 then 0 else
CONVERT(INT,[Close Inventory(Dec.12)])/CONVERT(INT,[ST Weekly Average]) end
转载于:https://www.cnblogs.com/yuanweisen/archive/2009/01/05/1369164.html