create storeprocedure dbo.CalcStore(@spbh varchar(100),@rq1 datetime,@rq2 datetime)
as
begin
    create table #tempStore(序号 int, 日期 datetime null, 摘要 varchar(100), 入库数 int null, 出库数 int null, 库存 int);
    set rq2 = dateadd(d, rq2, 1);
    declare cursor curData for
        select (ywrq, djbh, type, s1) from (
            select ywrq, djbh, 1 as type, s1, spbh from vcg_wzrkd
            union
            select ywrq, djbh, -1 as type, s1, spbh from vcg_wzckd
        ) where spbh = @spbh and ywrq >= rq1 and ywrq < rq2 order by ywrq asc
    declare @no int;
    declare @store int;
    declare @rq datetime;
    declare @djbh varchar(100);
    declare @s1 int;
    declare @type int;
    set @no = 1;
    set @store = (select sum(s1) from vcg_wzrkd where spbh = @spbh and ywrq < rq1)
           - (select sum(s1) from vcg_wzckd where spbh = @spbh and ywrq <rq1);
    insert into #tempStore (序号,摘要, 库存) values (@no, @spbh, @store);
    fetch curData into @rq, @djbh, @type, @s1;
    while @@error_level <> 0
    begin
        set @no = @no + 1;
        if @type = 1
        begin
            set @store = @store + @s1;
            insert into #tempStore (序号,日期, 摘要, 入库数, 库存) values (@no, @rq, @djbh, @s1, @store);
        end
        else
        begin
            set @store = @store - @s1;
            insert into #tempStore (序号,日期, 摘要, 出库数, 库存) values (@no, @rq, @djbh, @s1, @store);
        end
        fetch curData into @rq, @djbh, @type, @s1;
    end
    select * from #tempStore;
end