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
Navigation:
[Reply to this message]
|