CREATE PROCEDURE proc_sale_branch_month
(
@startdate datetime,
@enddate datetime,
@branch_no varchar(6)
)
AS
declare @sumAmount numeric(16,6)
set @sumAmount=
(select sum(case kp_trans_no when 'SO' then 订单金额 else 0 end)-sum(case kp_trans_no when 'RI' then 订单金额 else 0 end)
from
(
SELECT b.kp_trans_no, SUM(a.kp_sub_amt) AS 订单金额
FROM dbo.pf_dj_detail a , dbo.pf_dj_master b
where
a.kp_sheet_no = b.kp_sheet_no
and (b.kp_approve_flag = '1')
and (b.kp_oper_date >=@startdate) and (b.kp_oper_date<=@enddate)
and (b.kp_branch_no like @branch_no)
GROUP BY b.kp_trans_no
) bbb
)
begin
select 年月,kp_branch_no,(select kp_branch_name from jb_jgck where kp_branch_no=aaa.kp_branch_no) as '仓库',
sql 销售月报表
最新推荐文章于 2022-04-11 20:50:54 发布
创建了一个名为proc_sale_branch_month的存储过程,用于根据输入的开始日期、结束日期和分支编号,计算销售月报表,包括订单数量、销售额、退货数量、退货金额等详细指标,并按仓库和年月进行分组,最后计算出各分支的销售占比。
摘要由CSDN通过智能技术生成