Re: count occurrences by month

[Peter Brawley]

Assuming a table maint( loc id, dt datetime, ... ) andassumingt the requirement is for year-by-year monthly sums ...

select loc, left(dt,7) as yrmo, count(*) N
from maint
group by loc, yrmo
order by loc, yrmo;

If you don't need yearly data, change yrmo to month(dt) as mo, but you'll need to normalise results for the number of months represented in the table.