How to get randowm records with no dulicates. i am using sql server 2000 and a store procedure.
Select Distinct ...<BR><BR>Order by newid()<BR><BR>
Thanks...for replying.<BR><BR>should i use about statement after RAND() function? <BR><BR>num_recs = total number of records. <BR><BR>ID = round(num_recs * rand(),0,1)<BR>
Thanks. it worked. Its easy than using Rand function and store procedure.