>>>
>>>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?
Something simple like
declare @counter int, @AddStr varchar(8)
set @counter = 10000000
while @counter >5
begin
insert into Table1 values ('First' + @AddStr, ...)
insert into tabl2 values (@@IDENTITY, Here I want a random Symbol, Random Qty and an average price for that Symbol)
set @counter = @counter - 1
end
If it's not broken, fix it until it is.
My Blog