Put The Fruit In The Basket, Sql Server

Language: Layout:

declare @dbApple TABLE(
FromDate date NOT NULL,
ToDate date NOT NULL,
Name varchar(30) NOT NULL,
Count int NOT NULL);

declare @dbOrange TABLE(
FromDate date NOT NULL,
ToDate date NOT NULL,
Name varchar(30) NOT NULL,
Count int NOT NULL);

declare @dbMango TABLE(
FromDate date NOT NULL,
ToDate date NOT NULL,
Name varchar(30) NOT NULL,
Count int NOT NULL);

INSERT INTO @dbApple
(FromDate,ToDate,Name,Count) VALUES ('2019-10-05','2019-10-09','APPLE','3');

INSERT INTO @dbOrange
(FromDate,ToDate,Name,Count) VALUES ('2019-10-10','2019-10-14','ORANGE','2');

INSERT INTO @dbMango
(FromDate,ToDate,Name,Count) VALUES ('2019-10-15','2019-10-19','MANGO','4');

WITH UNPEELED AS 
    (
       SELECT FromDate, ToDate, Name, Count
       FROM @dbApple
       UNION ALL
       SELECT FromDate, ToDate, Name, Count
       FROM @dbOrange
       UNION ALL
       SELECT FromDate, ToDate, Name, Count
       FROM @dbMango
    ),
    PEELED AS
    (
        SELECT 
         FromDate as [Date], 1 as Lvl,
         FromDate, ToDate, Name, Count
        FROM UNPEELED

UNION ALL
 
        SELECT 
         DATEADD(day,1,[Date]), Lvl +1, 
         FromDate, ToDate, Name, Count
        FROM PEELED p
        WHERE [Date] < ToDate
    )
    SELECT [Date], [Name], 
    CASE WHEN Lvl <= Count THEN 1 END AS [Count]
    FROM PEELED
    ORDER BY [Date];

View schema
Execution time: 0,02 sec, rows selected: 15, rows affected: 3, absolute service time: 0,22 sec, absolute service time: 0,23 sec