I don't understand what the bigints have to do with it. For a real or virtual table of numbers that goes from 1-N:
select startnum + (num-1)
from numtable
where num <= rangevalue
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service