dwain.c (9/19/2012)

---

There's a (usually) faster way:

SELECT col

FROM @t

CROSS APPLY (

VALUES (col1), (col2), (col3), (col4)) a(col)

This article describes the CROSS APPLY VALUES approach to UNPIVOT: http://www.sqlservercentral.com/Authors/Articles/Dwain_Camps/1444841/ including some information on the performance characteristics. More detailed performance results can be found in the associated discussion thread.