with SeqNumTbl AS (
  select 1 AS SeqNum
  union ALL
  select SeqNum + 1
  from SeqNumTbl
  where SeqNum < 100
)

select SeqNum
from SeqNumTbl;