22,300
社区成员




select a.buytime,sum(b.cnt) cnt
from
(
select CONVERT(varchar(10),DATEADD(D,-number,DATEADD(D,0,DATEDIFF(D,0,getdate()))),120) buytime
from master..spt_values where type='p' and number<90
) a
LEFT JOIN
(
select CONVERT(varchar(10),buytime,120) buytime,count(id) cnt
from tb
group by CONVERT(varchar(10),buytime,120)
) b on datediff(d,b.buytime,a.buytime)<90
select a.buytime,isnull(b.cnt,0) cnt
from
(
select CONVERT(varchar(10),DATEADD(D,-number,DATEADD(D,0,DATEDIFF(D,0,getdate()))),120) buytime
from master..spt_values where type='p' and number<90
) a
LEFT JOIN
(
select CONVERT(varchar(10),buytime,120) buytime,count(id) cnt
from tb
group by CONVERT(varchar(10),buytime,120)
) b on a.buytime=b.buytime
select count(id) from tb
where buytime>=DATEADD(D,0,DATEDIFF(D,0,getdate())-90)