>>>>

>>>>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?
>
>I think to make things easier and not to run select inside the loop I would just hardcode 5 cases depending on mod(counter) - need to find the equavalent T-SQL function.

 int1 % int2