drop proc alldate
go
create PROCEDURE alldate
@beginDate datetime ,
@endDate datetime
as
--create table temp (id int identity(1,1),date datetime,mins datetime,maxs datetime)
truncate table temp
declare @i int
set @i = 0
while @i <=datediff(dd,@beginDate,@endDate)
begin
declare @date datetime
set @date=convert(char(10), dateadd(dd,@i,@beginDate),120)
insert into temp(date,mins,maxs)
select @date ,min(t_visitorrecord.start ) ,
max(t_visitorrecord.endtime) from t_visitorrecord where datediff(dd,start,@date)=0 and datediff(dd,endtime,@date)=0
set @i = @i +1
end
查询某段时间内 每一天的最高记录和最低记录
最新推荐文章于 2020-12-31 11:28:18 发布