>>
>>SELECT TOP xxx *, NEWID() as Test
>> FROM YoutTable
>>ORDER BY NEWID()
>>
>>
>>where xxx is any number from 1 to ...
>>
>>I thought you want to SET values not to SELECT records
>
>Funny thing that I posted this solution long time ago here (don't recall where did I pick it, from tek-tips, I believe).
>
>Anyway, I want to insert about a million records and I want to somehow don't have the same values. What would be the best approach?
>
>BTW, I found that I only inserted about 10K records. Missed one zero in my counter, I guess.
Yeah,
From tek-tips it is :-)
What you have as insert routine?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.