• SELECT YearNumber,

    MonthNumber,

    SUM(Occurances) AS CountOfData

    FROM

    (select YEAR(DateField) AS YearNumber,

    MONTH(DateField) AS MonthNumber,

    Count(datacount) As Occurances

    FROM

    datatable

    GROUP BY SQLDate)Dates

    GROUP BY YearNumber,

    MonthNumber

    Order By YearNumber,

    MonthNumber

    This should give you what you are looking for.