• Couldn't you just unpivot your data? Something like:

    SELECT DISTINCT SpecificCols

    FROM

    (SELECT col1, col2, col3, col4

    FROM @t) t

    UNPIVOT

    (SpecificCols FOR AllCols IN (col1, col2, col3, col4)) AS unpvt;

    HTH,

    Rob