How about using an IDENTITY column with a starting seed of 10,000,000.
Andrew J. Kelly
SQL Server MVP
"Tonny René Poulsen" <2003pc.dk> wrote in message
news:%23EYbaSBQDHA.2244TK2MSFTNGP11.phx.gbl...> Hi there.
> I need to populate a table with, hold on, 90.000.000 entries.
> They have to unique, starting with 10.000.000 and ending with 99.999.999.
> I reckon that i have to use a FOR-NEXT loop and maybe have to use some
> VBScript, but i rather that it was a SQL statement.
> Can anyone help me with the code?
> Regards tonny