22,300
社区成员




select
ws.cNCCode bandNCCode,
ws.cNCName bandNCName,
ws.cSpecs bandSpecs,
ws.cModel bandModel,
ws.cUnit bandUnit,
ww.cWareName bandWareName,
wc.cChannelName bandChannelName,
ISNULL(dr.今日入库 ,0) inToday,
ISNULL(dc.今日出库 ,0) outToday
from WI_SteelNC ws
left join
(select s.pk_steelNC,h1.pk_warehouse,h1.pk_channel,SUM(CONVERT(decimal(19,2),b1.fTotalWeight)) AS 今日入库
from WI_SteelNC s
left join EV_InStock_b b1 on b1.pk_steelNC = s.pk_steelNC
left join EV_InStock_h h1 on h1.IShId = b1.ISbId
left join WI_WareHouse w1 on w1.pk_warehouse = h1.pk_warehouse
left join WI_Channel c1 on c1.pk_channel = h1.pk_channel
where datediff(day,CONVERT(datetime,h1.dNewDate,120),CONVERT(datetime,'2020-09-14 17:20:52.837',120))=0 and h1.iState !=2
group by s.pk_steelNC,h1.pk_warehouse,h1.pk_channel)
dr on dr.pk_steelNC = ws.pk_steelNC
left join
(select s.pk_steelNC,h2.pk_warehouse,h2.pk_channel,SUM(CONVERT(decimal(19,2),b2.fTotalWeight)) AS 今日出库
from WI_SteelNC s
left join EV_SaleWZ_b b2 on b2.pk_steelNC = s.pk_steelNC
left join EV_SaleWZ_h h2 on h2.WZhId = b2.WZhId
left join WI_WareHouse w1 on w1.pk_warehouse = h2.pk_warehouse
left join WI_Channel c1 on c1.pk_channel = h2.pk_channel
where datediff(day,CONVERT(datetime,h2.dNewDate,120),CONVERT(datetime,'2020-09-14 17:20:52.837',120))=0 and h2.iState !=2
group by s.pk_steelNC,h2.pk_warehouse,h2.pk_channel)
dc on dc.pk_steelNC = ws.pk_steelNC
left join WB_StockNC wsn on wsn.pk_steelNC = ws.pk_steelNC
left join WI_WareHouse ww on ww.pk_warehouse = wsn.pk_warehouse
left join WI_Channel wc on wc.pk_channel = wsn.pk_channel
order by ws.pk_steelNC,ww.pk_warehouse,wc.pk_channel