SELECT DATEPART(MM,VISITINGDATE),SUM(COST) FROM yourtable
GROUP BY DATEPART(MM,VISITINGDATE)
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server