Summary: in this tutorial, you will learn how to use the SQL Server PIVOT operator to convert rows to columns.
Setting up the goals #
For the demonstration, we will use the production.products and production.categories tables from the sample database: