SELECT CustomerID, Quarter, Revenue FROM Sales.FactQuarters UNPIVOT (Revenue FOR Quarter IN ([Q1_2014],[Q2_2014],[Q3_2014],[Q4_2014],...,[Q4_2024])) AS unpvt;
To review the changes, John created a new query by clicking on "New Query" in the toolbar or pressing Ctrl + N. A new window opened, and he was presented with a blank query editor. sql studio 2014
After verifying the changes, John deployed them to the production environment. He used the "Deploy Database" feature in SSMS to script out the changes and deploy them to the production server. SELECT CustomerID, Quarter, Revenue FROM Sales
With the schema changes reviewed, John created a new query to test the modifications. He added a new column to the table using the following statement: He used the "Deploy Database" feature in SSMS
The little red squiggly line appeared under UNPIVOT . SSMS 2014’s parser didn't highlight syntax errors in real-time – but the did something worse when I pressed F5 :