T-SQL Querying

by Ben-Gan Itzik

SELECT empid, orderyear, val FROM dbo.EmpYearValues UNPIVOT( val FOR orderyear IN([2013],[2014],[2015]) ) AS U;

unpivot