java sqlserver 日期_sqlserver 时间递增循环

--查询指定供应商指定的一段时间内出票的张数

如果每查询一个月，修改一次时间太麻烦，写个循环的！

declare @date1 date

declare @date2 date

declare @startdate date

declare @enddate date

declare @countsum int

declare @count int

set @startdate='2010-06-01'

set @enddate='2011-07-01'

set @count=1

set @countsum=DATEDIFF(MM,@startdate,@enddate)

set @date1=@startdate

set @date2=dateadd(mm,1,@startdate)

while @count

begin

--执行sql

SELECT SUM(PassengerCount) AS 张数 FROM dbo.Orders WHERE ProviderID =

(SELECT UserId FROM dbo.User

WHERE Username='wind2006')

and OrderTime Between @date1 and @date2

set @date1=dateadd(mm,1,@date1)

set @date2=dateadd(mm,1,@date2)

set @count=@count+1

end