Is it possible to have a tableless select with multiple rows?
UNPIVOT can transpose data from rows to columns. Multiple unpivots is equivalent to the Cartesian product of each unpivoted column.
SELECT N, S FROM (SELECT 1 aa, 2 ab, 3 ac, 'a' ba, 'b' bb, 'c' bc) s UNPIVOT (N for Num in (aa,ab,ac)) AS t UNPIVOT (S for Str in (ba,bb,bc)) AS u
N | S--+--1 | a1 | b1 | c2 | a2 | b2 | c3 | a3 | b3 | c