>I have a table of links which contains about 200 links. On a daily basis, I have a robot which generates randomly 2 selections. However, I have found a weird behavior. I have found that some selections are chosen frequently. For example, the list of Web sites of the day has been selecting the same two Web sites 3 times recently. An example of a simple SQL statement do generate that is the following:
>
>SELECT TOP 2 NUMERO,RAND(-1) AS Dummy FROM LINKS ORDER BY 2,1 INTO CURSOR TEMP
I think I forgot to have the statement RAND(-1) before and have it only RAND() in the SQL. It works better now.