用数字范围创建临时表

WITH    q AS        (        SELECt  startId, endId        FROM    ranges        UNIOn ALL        SELECt  startId + 1, endId        FROM    q        WHERe   startId < endId        )SELECt  startIdFROM    qOPTION  (MAXRECURSION 0)