Posted by FrankEBailey on 12/01/06 12:44

I'm not sure if this is a completely dumb question, but please humor me
:) I have a table of records, called Records, each of which has a
Category_ID that places it in a specific category; the details of the
categories are stored in another table called Category. What I need to
do is retrieve a recordset that contains one record from each category,
but where the records that are retrieved are random. I know how to
retrieve one or more random records using "order by NewID()", but have
not been able to work out how to get one random record from each
category.

Any assistance in this puzzler will be HUGELY appreciated!

Thanks
FEB

• Next in forum: Re: 10 Random records, 1 from each category
• Prev in forum: Re: PLEASE PLEASE HELP - How can I get a return value from a SQL Stored Proc is ASP.NET?
• Thread view: 10 Random records, 1 from each category

[Reply to this message]