https://stackoverflow.com/questions/42025762, Sql Server

Language: Layout:

--Sql Server 2014 Express Edition
--Batches are separated by 'go'

--Create Numbers table
DECLARE @RunDate datetime
SET @RunDate=GETDATE()
SELECT TOP 10000 IDENTITY(int,1,1) AS Number
    INTO Numbers
    FROM sys.objects s1       --use sys.columns if you don't get enough rows returned to generate all the numbers you need
    CROSS JOIN sys.objects s2 --use sys.columns if you don't get enough rows returned to generate all the numbers you need
ALTER TABLE Numbers ADD CONSTRAINT PK_Numbers PRIMARY KEY CLUSTERED (Number)
go

--Create item table and insert test rows
create table item_table(item int, quantity int, [date] date);
go

insert item_table
select 1, 10, '1/1/2017' union
select 1, 12, '1/2/2017' union
select 1, 20, '1/3/2017' union
select 1, 22, '1/4/2017' union
select 2, 11, '1/1/2017' union
select 2, 32, '1/2/2017' union
select 2, 15, '1/3/2017' union
select 2, 12, '1/4/2017';
go

select i.item, 
i.date, 
sum(i.quantity) over (partition by i.item order by i.date) quantity
from item_table i
join Numbers n on i.date = DATEADD(dd, -1*n.Number, convert(date, getdate()))
where n.Number <= 365

View schema
Execution time: 0,05 sec, rows selected: 9, rows affected: 8, absolute service time: 0,22 sec