issue regarding stored procedure

Based upon what little you gave us in the question, here is an answer that you will have to adapt to your particular environment but which should work:

SELECT rowMonth, rowYear, SUM(rowMoneyData) AS Total
FROM (
   SELECT Month(rowDate) AS rowMonth, Year(rowDate) AS rowYear, rowMoneyData
   FROM yourTable) AS convertedTable
WHERE rowMonth = 3
GROUP BY rowYear, rowMonth

What this does is it first creates a sub-query that includes just the data you need and gives you month and year numbers for each row. Then we use that sub-query in our main query to group by and filter. Since you wanted just March data, I filtered it by month number 3.

You could do this without the sub-query but it wouldn't be as performant because you would need to do the conversion to month twice instead of once (once in the Group By and once in the Where).

The results of this query would be the total for March for each year on a separate line.