Generate repeating data based on date range

I want to create a view with result like this in SQL Server,

from data table with date range per row (start date – end date), can generate repeating data based on a date range to get the number of months for repeating data (by displaying the date of the beginning of each month).

data table

result view

Can it be creating using View without creating a function?

>Solution :

I would approach this using a recursive CTE:

WITH cte AS (
    SELECT name, debt, DATETRUNC(month, start_date) AS start_date, end_date
    FROM mytable
    UNION ALL
    SELECT m.name, m.debt, DATEADD(month, 1, c.start_date), m.end_date
    FROM mytable m
    JOIN cte c ON c.name = m.name
                  AND DATEADD(month,1,c.start_date) < m.end_date
)
SELECT *
FROM cte
ORDER BY name, start_date;

Results :

name    debt    start_date  end_date
A       100     2022-01-01  2022-03-31
A       100     2022-02-01  2022-03-31
A       100     2022-03-01  2022-03-31
B       50      2022-01-01  2022-02-28
B       50      2022-02-01  2022-02-28
C       80      2023-02-01  2023-02-28

Demo here