*** Returning a Set Number of Random Records ***

[jonnywah]

I have the following code where @chemicalTypeId is a parameter in my stored procedure GetRandomChemicals:

select * from chemicals
where chemicalTypeId1 = @chemicalTypeId
or chemicalTypeId2 = @chemicalTypeId
or chemicalTypeId3 = @chemicalTypeId
or chemicalTypeId4 = @chemicalTypeId

GetRandomChemicals should return up to 6 chemicals with a chemicalTypeId (1 to 4) that is equal to @chemicalTypeId.

GetRandomChemicals can return from 0 records to hundreds of records. However I want to randomly return up to a maximum of 6 records / chemicals each time the stored procedure is called.

How can I do this?? Please help. Any suggestions or information would be appreciated. Thank you in advance.

 

[hmckillop]

Have a look at the faqs

http://www.tek-tips.com/faqs.cfm?spid=183&sfid=1143

"Own only what you can carry with you; know language, know countries, know people. Let your memory be your travel bag.