This pair of T-SQL commands always seem odd to cover in tandem because they’re not opposites. However, I feel like it’s more confusing to describe them apart from each other. Plus, it’s not like they don’t have any similarities.
Well, as promised, here are the slides and scripts from my presentation: T-SQL PIVOT & UNPIVOT (ZIP).
If you have any questions about the content, drop me a line.