SQL Server Time Series - a basic transformation

sql-server,sql-server-2008,dmx-ssas

What you want is typically achieved using PIVOT: SELECT [Date], [Temperature], [SnowLevel], [Humidity] FROM ( SELECT [Date], Parameter, Value FROM #MainTable )src PIVOT ( MAX(Value) FOR Parameter IN ([Temperature], [SnowLevel], [Humidity]) ) pvt The above query produces the following output based on the sample data of the OP: Date Temperature...