I was wondering where to go from my initial idea. I used the query below to get the month beginning dates for each of the three years:

```
DECLARE @STARTDATE DATETIME,
    @ENDDATE DATETIME;

SELECT  @STARTDATE='2013-01-01 00:00:00.000',
    @ENDDATE='2015-12-31 00:00:00.000';

WITH [3YearDateMonth]
AS
(
    SELECT TOP (DATEDIFF(mm,@STARTDATE,@ENDDATE) + 1)
        MonthDate = (DATEADD(mm,DATEDIFF(mm,0,@STARTDATE) + (ROW_NUMBER() OVER (ORDER BY (SELECT NULL)) -1),0))
    FROM sys.all_columns ac1
)
SELECT MonthDate
FROM [3YearDateMonth]

```

I am not sure if I should DATENAME(Month, Monthdate) it later for the month names or just do it in the cte; any suggestions would be great.

My data looks like this:

```
BeginDate               EndDate                 Payment
2013-01-01 00:00:00.000 2013-12-31 00:00:00.000 3207.70
2014-01-01 00:00:00.000 2014-12-31 00:00:00.000 3303.93
2015-01-01 00:00:00.000 2015-12-31 00:00:00.000 3403.05

```

Since the payment is yearly I can use payment/12 to get an average monthly amount. I want my data to look like this:

```
BeginDate               EndDate                 Month    MonthlyAmount  
2013-01-01 00:00:00.000 2013-01-31 00:00:00.000 January  267.3083
2013-02-01 00:00:00.000 2013-02-31 00:00:00.000 February 267.3083
...
2014-01-01 00:00:00.000 2014-01-31 00:00:00.000 January  275.3275
2014-02-01 00:00:00.000 2014-02-31 00:00:00.000 February 275.3275
...
2015-01-01 00:00:00.000 2015-01-31 00:00:00.000 January  283.5875
2015-02-01 00:00:00.000 2015-02-31 00:00:00.000 February 283.5875
All the way through December for each yearly pay period.

```

I will be pivoting the Month column later to put the monthly amounts under the corresponding month they belong in.

Is this doable because I feel lost at this point?