• 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