pivot operator

Pivot Tables and Reporting in SQL

Evgeniy Gribkov

Evgeniy is an MS SQL Server database analyst, developer, and administrator. He is involved in the development and testing of the SQL Server database management tools. Evgeniy also writes SQL Server-related articles.
Evgeniy Gribkov

Quite enough, there’s a need to change how data is displayed in a database so that the users could analyze it more easily. One of the cases of such transformation is transposing data from rows to columns in SQL Server.

(more…)

Is UNPIVOT the best way for converting columns into rows?

To start, let’s give definitions and highlight the difference between PIVOT and UNPIVOT operators in SQL Server.

(more…)