hi again,

i just want to ask if how can i randomly select 5 distinct records from a table w/ a hundreds of records everytime i exec a stored procedure??

thanks

Try this:

SELECT TOP (5) * FROM authors ORDER BY newid()

Hello smoothmovz,

You can add the CheckSum() encapsulating the NEWID() function in the orer by clause 

SET @n = 5

Eralper

Select top n records or random n records for each category

thanks for your helpful replies, can you help me with my other problem. here's my post:

http://forums.asp.net/p/1259677/2351246.aspx#2351246