--创建测试临时表
If OBJECT_ID('tempdb..#temp') is not null drop table #temp
Create table #temp(MyDate date,
OrderNums int
)
--插入测试数据
insert into #temp values ('2017-09-01',1),('2017-09-02',2),('2017-09-03',3),('2017-09-04',4)
--查询
select adate,sum(OrderNums) from(select a.MyDate adate,b.MyDate bdate,b.OrderNums
from #temp a left join #temp b on b.MyDate<=a.MyDate) b group by adate