不需要存储过程就可以实现的啊!select sum(a.yyk), sum(a.ssk), sum(b.yyk) ,sum(b.ssk) from a,b where a.ghid=b.ghid and (convert(char(15,a.ghsj,120)) between '开始日期' and '结束日期') and (convert(char(15,b.ghsj,120)) between '开始日期' and '结束日期' )
调试欢乐多
AS
select sum(a.yyk), sum(a.ssk), sum(b.yyk) ,sum(b.ssk) from a,b
where a.ghid=b.ghid
and (convert(char(15,a.ghsj,120)) between '开始日期' and '结束日期')
and (convert(char(15,b.ghsj,120)) between '开始日期' and '结束日期' )GOEXECUTE pname1
2005-11-01 20.00 20.00 30.00 30.00
2005-11-02 20.00 20.00 30.00 30.00
2005-11.03 .....的格式
AS
select sum(a.yyk), sum(a.ssk), sum(b.yyk) ,sum(b.ssk) from a,b
where a.ghid=b.ghid
and (convert(char(15,a.ghsj,120)) between '开始日期' and '结束日期')
and (convert(char(15,b.ghsj,120)) between '开始日期' and '结束日期' )
group by date
GOEXECUTE pname1
AS
select convert(vrchar(10),date,120) as date,sum(a.yyk), sum(a.ssk), sum(b.yyk) ,sum(b.ssk) from a,b
where a.ghid=b.ghid
group by convert(vrchar(10),date,120)
GO
AS
select convert(varchar(10),date,120) as date,sum(a.yyk), sum(a.ssk), sum(b.yyk) ,sum(b.ssk) from a,b
where a.ghid=b.ghid
group by convert(varchar(10),date,120)
GO