You can pivot data in SQL Data Warehouse by using a CASE statement. This article contains two simple examples on how to both pivot and unpivot a table without using the pivot and unpivot syntax found ...