create proc GetUserCount(
@Type int, --为1按周统计,为其它按月统计
@SDate int,
@EDate int
)as
if @Type=1
begin
select datename(week,logdate) as weeks,COUNT(*) as usercount
from (select distinct logdate,number from Log_PlayTime)
where datename(week,logdate) between @SDate and @EDate
group by datename(week,logdate)
end
else
begin
select datename(month,logdate) as months,COUNT(*) as usercount
from (select distinct logdate,number from Log_PlayTime)
where datename(month,logdate) between @SDate and @EDate
group by datename(month,logdate)
having COUNT(*)>3
end
return
go
<!--EndFragment-->