Stored procedure to transform a 'select' result set such that each column value is presented on a separate row.
2016-12-08 (first published: 2015-01-26)
Generate and execute dynamically select statement for unpivot table
2014-04-17 (first published: 2014-03-25)
Have you ever wanted to dynamically unpivot a table?
2014-04-22 (first published: 2014-02-20)