Código SQL:
Ver originalCREATE TABLE #temp
(
id INT,
año INT,
mes INT
)
DELETE FROM #temp
INSERT INTO #temp VALUES (1,2011,10)
INSERT INTO #temp VALUES (2,2011,9)
SELECT * FROM #temp WHERE año=datepart(yy,getdate()) AND mes=datepart(mm,getdate())
Saludos!