sort of...still breaking it down... I was on that track originally with the following query, but it would run forever so I always cancelled it.

Declare @startdate datetime = cast(DATEADD(MONTH, DATEDIFF(MONTH,...

Thanks! That worked.