>>Hi everybody,
>>
>>How can I randomly select n (110) codes from some huge table, so these codes would be unique? I'm trying to create a test case now...
>
>Ok, I have an idea by myself.
>1) Select code group by 1 into cursor curTemp
>
>2) Randomly find a number between 1 and _tally (repeat 110 times)
> Put each record with this recno() in temp table.
How about :
rand(-1)
select top 110 rand(),* from mytable order by 1 into cursor myRands
Cetin