add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
--id | rent_id | start_date | end_date | amount
-----------------------------------------------
--1 | 54 | 12-10-2019 | 26-10-2019| 100
--2 | 54 | 13-10-2019 | 20-10-2019| 150



with rentals(id, rent_id, start_date, end_date, amount) as (
SELECT 1 as id, 54 as rent_id, CAST('2019-10-12' AS DATE) as start_date, CAST('2019-10-26' AS DATE) as end_date, 100 as amount
union all
SELECT 2 as id, 54 as rent_id, CAST('2019-10-13' AS DATE) as start_date, CAST('2019-10-20' AS DATE) as end_date, 150 as amount
),
days(i) as (
select CAST('2019-10-11' as DATE)
union all
select DATEADD(d,1,i) from days where i<= '2019-10-27'
)

select
i ,
(SELECT ISNULL(SUM(amount),0) FROM rentals WHERE start_date<=i and end_date>=i) as amount
from days



i amount
2019-10-11 0
2019-10-12 100
2019-10-13 250
2019-10-14 250
2019-10-15 250
2019-10-16 250
2019-10-17 250
2019-10-18 250
2019-10-19 250
2019-10-20 250
2019-10-21 100
2019-10-22 100
2019-10-23 100
2019-10-24 100
2019-10-25 100
2019-10-26 100
2019-10-27 0
2019-10-28 0