寫一段方便的SQL 迴圈查每一天的資料

標籤：style   blog   color   ar   資料   2014   div   sp   log   

declare @recd int,@i int,@a int,@count int,@day1 date,@day2 date,@days intset @recd=0set @i=0set @a=0set @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 sumpinto #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+1endselect * from #tppdrop table #tpp

每天的查詢需求太頻繁，想了一個辦法把所有事情交給電腦來完成,好久不來。今天上來轉轉

寫一段方便的SQL 迴圈查每一天的資料