将标题行扩展为多个子行

使用

tally table

WITH lv0 AS (SELECt 0 g UNIOn ALL SELECT 0 UNIOn ALL SELECT 0 UNIOn ALL SELECT 0 UNIOn ALL SELECT 0 UNIOn ALL SELECT 0 UNIOn ALL SELECT 0 UNIOn ALL SELECT 0 UNIOn ALL SELECT 0 UNIOn ALL SELECT 0)    ,lv1 AS (SELECT 0 g FROM lv0 a CROSS JOIN lv0 b) --10 * 10 =  100    ,lv2 AS (SELECt 0 g FROM lv1 a CROSS JOIN lv0 b) --100 * 10 = 1000    ,Tally (num) AS (SELECt ROW_NUMBER() OVER (ORDER BY (SELECT NULL)) FROM lv2)    SELECt (num+StartNo-1) as TicketNo, *    FROM   TallyCROSS JOIN Yourtable    WHERe  num <= booksize    ORDER  BY book