SET NOCOUNT ON

CREATE TABLE Table1
(
Column1 INT NOT NULL,
Column2 DATETIME NOT NULL
)

INSERT INTO Table1 VALUES(91, '2003-07-01') 
INSERT INTO Table1 VALUES(132, '2003-04-01') 
INSERT INTO Table1 VALUES(91, '2002-07-01')
INSERT INTO Table1 VALUES(132, '2001-04-09')
INSERT INTO Table1 VALUES(132, '2003-07-09') 
INSERT INTO Table1 VALUES(2, '2003-07-23') 
INSERT INTO Table1 VALUES(2, '2003-07-31') 
INSERT INTO Table1 VALUES(132, '2003-07-21')

SELECT TOP 10 Column1, COUNT(Column1) AS Hits
FROM Table1
WHERE DATEPART(month, Column2) = MONTH(GETDATE()) AND DATEPART(year, Column2) = YEAR(GETDATE())
GROUP BY Column1
ORDER BY COUNT(Column1) DESC

DROP TABLE Table1

--------Results--------

Column1     Hits        
----------- ----------- 
2           2
132         2
91          1