Explain UNPIVOT with example in SQL Server.
Explain UNPIVOT with example in SQL Server.
Ask by Steilla Mitchel
Updated 14 Jan 2025
UNPIVOT, which works with SQL Server is used to turn columns into rows. This is especially valuable in cases when you have to normalize your data or when you prefer to transform a table consisting of columns containing similar data into a table with more rows and one column.Syntax of
UNPIVOT:value_column: The column into which the values of the columns in the transformation process will be migrated.name_column: The column that will hold the names of the original columns as well.column_list: The name of the columns that would be unpivoted.Use Cases:
Data Normalization: Converting a wide dataset into a tall format for easier analysis.
Reporting: Generating row-based reports from columnar data.
Integration: Preparing data for systems that require row-based data instead of columnar.
By using
UNPIVOT, you can easily transform your data into the desired format.