problems with random select on server

[Paulo Fabiano]

hi all, i´m using the command bellow:

select top 3 * from <table> order by rnd(<field>)

it works perfectly at my computer (xp pro IIS 5)
the command return 3 randomic fields

but when I put it on the server it´s does not work
the command return the SAME 3 registers always.
and they´re not the first 3 and even aren´t the last 3.

the 3 returned fields are in the middle of the table.

any one can help me?

[]´s

 

[[MVP] S. Clark]

Is this an Access Database?
Is the server that you are referring SQL Server?

What are you trying to accomplish with the Rnd() in the Order By?

--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

hi all, i´m using the command bellow:

select top 3 * from <table> order by rnd(<field>)

it works perfectly at my computer (xp pro IIS 5)
the command return 3 randomic fields

but when I put it on the server it´s does not work
the command return the SAME 3 registers always.
and they´re not the first 3 and even aren´t the last 3.

the 3 returned fields are in the middle of the table.

any one can help me?

[]´s