34,588
社区成员
发帖
与我相关
我的任务
分享
select
业务员,
仓库,
sum(本地库数量SPSL) 本地库出库吨数,
sum(直发库数量SPSL) 直发库出库吨数
from (
select *
from
(select
y.ywbh,
y.ywxm 业务员,
w.ckbh 仓库编号,
ckmc 仓库,
isnull((select top 1 SPSL from xsjsb where w.ckbh!=1004 ),0) 本地库数量SPSL, //
isnull((select top 1 SPSL from xsjsb where w.ckbh=1004 ),0) 外地库数量SPSL //如何实现select SPSL from xsjsb where w.ckbh=1004
From
xsjsb w left join xsjs t on w.link=t.link
left join d_sp s on s.spbh=w.spbh
left join d_ywy y on t.ywbh=y.ywbh
left join d_bm b on t.bmbh=b.bmbh
left join d_ck ck on ck.ckbh=w.ckbh
left join d_czy zd on zd.czbh=t.zdrm
left join d_czy fh on fh.czbh=t.fhrm
left join d_czy jz on jz.czbh=t.jzrm
where
rq>= '[开始日期,DATE]' and rq<= '[结束日期,DATE]'
)a
)b group by 业务员
select
业务员,
仓库,
sum(本地库数量SPSL) 本地库出库吨数,
sum(直发库数量SPSL) 直发库出库吨数
from (
select
y.ywbh,
y.ywxm 业务员,
w.ckbh 仓库编号,
ckmc 仓库,
isnull(l.本地库数量SPSL,0) 本地库数量SPSL, //
isnull(o.外地库数量SPSL,0) 外地库数量SPSL //如何实现select SPSL from xsjsb where w.ckbh=1004
From xsjsb w
left join xsjs t on w.link=t.link
left join d_sp s on s.spbh=w.spbh
left join d_ywy y on t.ywbh=y.ywbh
left join d_bm b on t.bmbh=b.bmbh
left join d_ck ck on ck.ckbh=w.ckbh
left join d_czy zd on zd.czbh=t.zdrm
left join d_czy fh on fh.czbh=t.fhrm
left join d_czy jz on jz.czbh=t.jzrm
outer apply (select top 1 SPSL as 本地库数量SPSL from xsjsb where w.ckbh!=1004 ) l
outer apply (select top 1 SPSL as 外地库数量SPSL from xsjsb where w.ckbh=1004 ) o
where
rq>= '[开始日期,DATE]' and rq<= '[结束日期,DATE]'
)b group by 业务员,仓库