Посчитать события по месяцам
01.01.2007
SELECT
YEAR([MyDateFiled]),
MONTH([MyDateFiled]),
COUNT(*)
FROM [SomeTable]
GROUP BY
YEAR([MyDateFiled]),
MONTH([MyDateFiled])
SELECT
YEAR([MyDateFiled]),
MONTH([MyDateFiled]),
COUNT(*)
FROM [SomeTable]
GROUP BY
YEAR([MyDateFiled]),
MONTH([MyDateFiled])