I am trying to write a query to have a result that indicates the months a project was active. I know how to get my start month and end month as numbers. I am struggling to figure out all the months in between.
Table: Projects
Desc Live_Date Duration_Months Project A 8/15/2020 4 Project B 6/12/2020 2
From the example above, here is the output of the query I want
Project Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Project A X X X X Project B X X