写一段方便的SQL 循环查每一天的数据

declare @recd int,@i int,@a int,@count int,@day1 date,@day2 date,@days int
set @recd=0
set @i=0
set @a=0
set @day1='2014-8-24'
set @day2='2014-8-25'
set @days=12 --设定12天
create table #tpp
(
    ID   int IDENTITY (1,1)     not null, --创建列ID,并且每次新增一条记录就会加1
    dateshow     date,
    dateend   date,
    num     int,   
    paynum  int,
    paymoney int,
    payordernum int
    primary key (ID)      --定义ID为临时表#Tmp的主键      
);
while(@i<@days)
begin

    if @i>0 
    begin
    set @a=1
    end
    set @day1=DATEADD(DAY,@a,@day1)
    set @day2=DATEADD(DAY,@a,@day2)
    
    SELECT userID,COUNT(1) as danshu,sum(payMoney) as sump
into #pp FROM [表] where paytime between @day1 and @day2 and status>0 group by userID
insert #tpp  select @day1 as day1,@day2 as day2,@i,(select COUNT(1) from #pp )as 充值人数,(select SUM(sump) from #pp) as 充值金额,(select SUM(danshu)   from #pp)as 充值单数
   drop table #pp
   

set @i=@i+1
end
select * from #tpp
drop table #tpp

每天的查询需求太频繁，想了一个办法把所有事情交给计算机来完成,好久不来。今天上来转转

转载于:https://www.cnblogs.com/fangyuan303687320/p/3958141.html