对咯这个是我写的一个sql,能够达到 时间 在线人数 2009-11-01 3 2009-11-02 5 2009-11-03 4 2009-11-04 0 2009-11-05 8 2009-11-06 9 这个效果,希望大家帮我完善下 create table Info ( tm datetime, sm int ) go insert info select '2009-01-01',3 union all select '2009-01-02',10 union all select '2009-01-02',5 union all select '2009-01-02',7alter procedure getDateInfo ( @beginDate datetime, @endDate datetime ) as create table #temp ( ll datetime ) while(@beginDate<=@endDate) begin insert into #temp values(@beginDate) set @beginDate=DATEADD(d,1,@beginDate) end select a.ll,count(b.sm) from #temp as a left join Info as b on a.ll=b.tm group by a.ll gogetDateInfo '2009-01-01','2009-02-10'
时间 在线人数
2009-11-01 3
2009-11-02 5
2009-11-03 4
2009-11-04 0
2009-11-05 8
2009-11-06 9
这个效果,希望大家帮我完善下
create table Info
(
tm datetime,
sm int
)
go
insert info
select '2009-01-01',3 union all
select '2009-01-02',10 union all
select '2009-01-02',5 union all
select '2009-01-02',7alter procedure getDateInfo
(
@beginDate datetime,
@endDate datetime
)
as
create table #temp
(
ll datetime
) while(@beginDate<=@endDate)
begin
insert into #temp values(@beginDate)
set @beginDate=DATEADD(d,1,@beginDate)
end select a.ll,count(b.sm) from #temp as a left join Info as b on a.ll=b.tm group by a.ll
gogetDateInfo '2009-01-01','2009-02-10'