我是这样写的:
CREATE PROCEDURE [p_a] @DateT DateTime AS
select A.mc,Sum(B.qckc) +Sum(B.rsc)-Sum(B.rxh) as jrkc,sum(A.rsc) as rsc,
Sum(A.ysc) as ysc,Sum(A.nsc) as nsc,Sum(A.rxh) as rxh,Sum(A.yxh) as yxh,Sum(A.nxh) as nxh,
Sum(A.qckc)+Sum(A.rsc)-Sum(A.rxh) as zrkc
from T_aa A,T_aa B
where convert(char(10),A.t1,102)=convert(char(10),B.t1-1,102) and convert(char(10),B.t1,102)=convert(char(10),@DateT,102) and A.mc=B.mc
Group By A.mc
GO
但昨日库存和今日库存两个库存数据不对,大家帮忙看看该怎么写?
CREATE PROCEDURE [p_a] @DateT DateTime AS
select A.mc,Sum(B.qckc) +Sum(B.rsc)-Sum(B.rxh) as jrkc,sum(A.rsc) as rsc,
Sum(A.ysc) as ysc,Sum(A.nsc) as nsc,Sum(A.rxh) as rxh,Sum(A.yxh) as yxh,Sum(A.nxh) as nxh,
Sum(A.qckc)+Sum(A.rsc)-Sum(A.rxh) as zrkc
from T_aa A,T_aa B
where convert(char(10),A.t1,102)=convert(char(10),B.t1-1,102) and convert(char(10),B.t1,102)=convert(char(10),@DateT,102) and A.mc=B.mc
Group By A.mc
GO
但昨日库存和今日库存两个库存数据不对,大家帮忙看看该怎么写?
CREATE PROCEDURE [p_bb] @DateT DateTime AS
select A.mc,Sum(A.qckc)+Sum(A.rsc)-Sum(A.rxh) +Sum(B.rsc)-Sum(B.rxh) as jrkc,sum(B.rsc) as rsc, --Sum(B.qckc) +Sum(B.rsc)-Sum(B.rxh) as jrkc
Sum(B.ysc) as ysc,Sum(B.nsc) as nsc,Sum(B.rxh) as rxh,Sum(B.yxh) as yxh,Sum(B.nxh) as nxh,
Sum(A.qckc)+Sum(A.rsc)-Sum(A.rxh) as zrkc,Sum(B.qckc) as qckc
from T_aa A,T_aa B
where convert(char(10),A.t1,102)=convert(char(10),B.t1-1,102) and convert(char(10),B.t1,102)=convert(char(10),@DateT,102) and A.mc=B.mc
Group By A.mc
即jrkc和zrkc不对