New Transact SQL Video Tutorial: Using the UNPIVOT Operator to Normalize Denormalized Tables and Datasets

Using the UNPIVOT Operator to Normalize Denormalized Tables and Datasets - view details

The opposite of the PIVOT operator is UNPIVOT. Since PIVOT creates cross tab queries (or "pivots" the data across the vertical and horizontal axis by turning row values into columns), UNPIVOT can take a crosstab query's resultset and normalize the results by turning the column data into rows. Make sense? If not, you need to watch this video!

---

• Source: http://www.LearnTransactSQL.com
• Category: Subqueries, Nested Queries, and Derived Tables in Transact SQL
• Skill Level: 300 (Intermediate)
• Length: 6:43 (4.58MB)
• Applies to Versions: SQL Server 2005
• Full Details

---

To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

---

Keywords Associated with this video: crosstab, cross tab, cross-tab, new feature, select, report, normalize, normalizing