This repository is dedicated to PL/SQL code used for my work. - PL-SQL/PIVOT y UNPIVOT.sql at main · CesarBeltranGarzon/PL-SQL ...

description: Learn about the Transact-SQL PIVOT and UNPIVOT relational operators. Use these operators on SELECT statements to change a table-valued expression into another table. You can use the ...

Some SQL gurus might disagree, and I wouldn't argue the point heavily, especially if you didn't plan on reading all the resulting rows (though why?).

PowerPivot with SQL Server 2008 R2 One of the prime-time features of Microsoft SQL Server 2008 R2 is provided by the “Project Gemini” technology known as PowerPivot for “Self Service BI”.