halo there.., i need some help on writing tis SQL.
i got a set of records in a table A.
i wan to query out a set of random record which consist of 10records. how can i query it? one more thing is, everytime when i refresh from my front page, the record will change? liek the dynamic random image display. plz help.

SELECT TOP 10 *
FROM TableA
ORDER BY NEWID()

Large number of records in TableA will take a long time because of the unindexed order by.

--Jeff Moden

hi Jeff Moden,
tis sql just will select the top 10 of the records, how can i do when i refresh a page in the front page, it will choose another set of records? tis can solve? thank you

The code above will select a different 10 rows randomly (provided there's more than 10 rows, of course) every time it is used. I don't know how to use it from Front Page but I suspect that, like any other GUI code, there is a way to build a record set either from a stored procedure or embedded SQL.

--Jeff Moden