Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Eli Leiba TSQL that lists all numbers from 1..100 RE: TSQL that lists all numbers from 1..100
ThomasGr
SSC Journeyman
Points: 92
More actions
February 20, 2012 at 6:03 am
#1449206
Try this one:
with t as (select 1 x
union all
select x + 1
from t
where x < 100)
select x