Add rows based on Start and End Date
I have the following table within my output Cust_No Start_Date End_Date Comp_Val Monthly_Val 123 2023-01-01 2023-06-30 1100 55.95 123 2023-07-01 2024-02-05 1100 22.90 As you can see, the months between start_date and end_date for this example, is 13+ months. What I would like to see is a row for each Year_Month between…
