Posted by WhytheQ on 08/16/07 10:39

This doesn't work:

--****************************************
USE myDatabase
SELECT TOP 10 *
FROM myTable
WHERE NEWID()
--****************************************

...I know I need to use the function newID() to find random records -
just don't know where it fits in the query (suspect the TOP will need
to go from the above)

Any help greatly appreciated
J

[Back to original message]