To get data in gridview of month and year which are less than current monthyear

I have same table as MonthlyDetails which have coulmn as MonthYear and  Amount.

Check the below stored procedure query for your referance.

-- EXEC GETMonthlyDetails
CREATE PROCEDURE GETMonthlyDetails
AS
BEGIN
	SELECT MonthYear , Amount
	FROM MONTHLYDETAILS
	WHERE CONVERT(DATETIME,(DATENAME(month,MONTHYEAR)+ DATENAME(year, MONTHYEAR))) 
		  < CONVERT(DATETIME,(DATENAME(month, GETDATE())+ DATENAME(year, GETDATE())))
END
GO