SELECT EmpID , DATENAME(Month, cast( Date as datetimeoffset)) as Month , sum(Expenditure) as TotalExpenditure FROM Employee GROUP BY EmpID, DATENAME(Month, cast( Date as datetimeoffset))
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)