FOR Month IN (January, February, March, April, May, June, July, August, September, October, November, December))
AS MonthNamePivot
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
Latest CV0-002 Dumps Valid Version with 328 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund