FOR Month IN (January, February, March, April, May, June, July, August, September, October, November, December))

FOR Month IN (January, February, March, April, May, June, July, August, September, October, November, December))

AS MonthNamePivot

View Answer

Answer: 1 SELECT * FROM

2 (SELECT YEAR(SalesData)) AS Year, DATENAME (MONTH, SalesDate) AS Month, SalesAmount AS Amount

3 FROM Products.Sales

4 ) AS MonthlySalesData

5 PIVOT SUM(Amount)

6 FOR Month IN (January, February, March, April, May, June, July, August, September, October, November, December)) AS MonthNamePivot