Posted by S�ren Reinke on 08/17/07 06:12

Hugo Kornelis wrote:
> 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.

Do you have a link to the book you are talking about ?

p.s. You blog is to large for pageflakes :( (max 512000 bytes) could you
maybe cut down the articles in the feed ?

Best regards
Søren

• Next in forum: How to create an admin with some limitations?
• Prev in forum: Re: Standard Schemas?
• Thread view: Re: SELECT a random 10 records from table....easy newbie question

[Reply to this message]