枚举N行N列的自然数列

/*枚举1-50的自然数列*/WITH    x0          AS ( SELECT   number               FROM     master..spt_values               WHERE    type = 'P'                        AND number >= 1                        AND number <= 50             )    /*行转列*/    SELECT  ( number - 1 ) / 5 + 1 AS 行号 ,            MAX(CASE WHEN number % 5 = 1 THEN number                END) AS 第一列 ,            MAX(CASE WHEN number % 5 = 2 THEN number                END) AS 第二列 ,            MAX(CASE WHEN number % 5 = 3 THEN number                END) AS 第三列 ,            MAX(CASE WHEN number % 5 = 4 THEN number                END) AS 第四列 ,            MAX(CASE WHEN number % 5 = 0 THEN number                END) AS 第五列    FROM    x0    GROUP BY ( number - 1 ) / 5

很简单。

（本文完）