SQL Server PIVOT operation which rotates a table-valued expression. It turns the unique values in one column into multiple columns in the output and performs aggregations by SUM (), COUNT (), AVG (), ...

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?).

SQL Server PIVOT (with calendar weeks) ElPresidente408 Jun 25, 2010 Jump to latest Follow Reply ...