or
CREATE PROCEDURE GetSalesValueASSELECT DATENAME(mm, Sales.SaleOrderDate) AS MonthOfSale , SUM(Quotes.NETPrice) AS SalesValue , Source.SourceFROM Quotes INNER JOIN Sales ON Quotes.QuoteId = Sales.QuoteId INNER JOIN Enquiry ON Quotes.EnquiryId = Enquiry.EnquiryId INNER JOIN Source ON Enquiry.SourceId = Source.SourceIdGROUP BY Sales.SaleOrderDate, Year(Sales.SaleOrderDate), Source.Source