"Andrew J. Kelly" wrote:

> The simplest way is to create the table with a column that has an IDENTITY
> property in the range you require. See IDENTITY in BooksOnLine for more
> details.
>
> --
> Andrew J. Kelly SQL MVP
> Solid Quality Mentors
>
>
> "PolarBear" <PolarBear@discussions.microsoft.com> wrote in message
> news:669D4D48-9ABE-451E-AFAC-3725F30162FC@microsoft.com...
> >I need to create a table and generate numbers for the ID field ranging from
> > 100001 thru 300000. In the next column, I will generate random numbers.
> > the
> > resulting table will then serve as a key for mapping purposes.
> >
> > I am OK on the random number aspect - however, what script is required to
> > generate the ID numbers?
> >
> > Regards,
> >
> > PolarBear
>