求时段统计存储过程
根据时段统计商品进货中进货总金额、进货退货总金额、销售总金额、销售退货总金额、期初数量（库存）、结存数量（库存）
选择对应的部门、组别、起始时间、结束时间，运行存储过程即可得到结果的存储过程
[解决办法]
给点数据看看
[解决办法]
上面你不是还有退货表吗？
[解决办法]
create proc uf_stock (@dept varchar(50)='',@sdate varchar(20)='',@edate varchar(20)='')
--exec uf_stock '仓库','20130506','20130825'
as begin
declare @consql varchar(max)
declare @sql varchar(max)
set @consql=''
if len(@dept)>0
set @consql=@consql+' and [部门] like ''%'+@dept+'''%'
if len( @sdate )>0
set @consql=@consql+' and [进货日期]>='''+@sdate+''' and [退货日期]>='''+@sdate
+''' and [销售日期]>='''+@sdate+''''
if len(@edate)>0
set @consql=@consql+' and [进货日期]<='''+@edate+''' and [退货日期]<='''+@edate
+''' and [销售日期]<='''+@edate+''''
set @sql='select 货号,sum(a.金额) as 期初金额,sum(b.金额) as 进货金额
,sum(c.金额) as 退货金额,sum(d.金额) as 销售总金额,
sum(e.金额) as 销售退货总金额 from 库存表 a left join (select * from
进货表 where 1=1'+@consql+')b on a. 货号=b.货号
left join (select * from 退货表 where 1=1'+@consql+' )c on a.货号=c.货号
left join (select * from 销售表 where 1=1'+@consql+')d on a.货号=d.货号
left join (select * from 销售退货表 where 1=1'+@consql+')e on a.货号=e.货号
group by 货号'
exec (@sql)
--print @sql
end
