CREATE PROCEDURE so @opendate as datetime,@enddate as datetime AS select sum(fund) as fund,createtime from tablename where createtime between in (@opendate and @enddate) group by createdate
Create PROCEDURE PROCEDUREName @OpenTime varchar(10), @EndTime varchar(10) AS Begin select CreateTime,sum(Fund) Fund From TableName where CreateTime between @OpenTime and @EndTime group by CreateTime end
Select sum(Fund) as fund from table where CreateTime between @OpenTime and @EndTime
create proc myProc @OpenTime --计算起始时间 @EndTime --计算的结束时间 as select CreateTime,sum(Fund) Fund From TableName where CreateTime between @OpenTime and @EndTime group by CreateTime
select sum(fund) as fund,createtime from tablename where createtime between in (@opendate and @enddate) group by createdate
@OpenTime varchar(10),
@EndTime varchar(10)
AS
Begin
select CreateTime,sum(Fund) Fund From TableName
where CreateTime between @OpenTime and @EndTime group by CreateTime
end
@OpenTime --计算起始时间
@EndTime --计算的结束时间
as
select CreateTime,sum(Fund) Fund From TableName
where CreateTime between @OpenTime and @EndTime group by CreateTime
http://community.csdn.net/Expert/topic/3185/3185749.xml?temp=.1830713
希望对你帮帮助。