Posted by Hugo Kornelis on 08/16/07 20:23

On Thu, 16 Aug 2007 03:39:49 -0700, WhytheQ wrote:

>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

Hi J,

Marcin's answer is correct. However, if you're on SQL Server 2005 you
can also use the new TABLESAMPLE option (see Books Online for the
details); this will probably perform better on large tables.

--
Hugo Kornelis, SQL Server MVP
My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis

[Back to original message]