RE: FN-FORUM Randomise Recordset in SQL7

date posted 11th January 2001 16:22

Thanks, guys. We also reached the same conclusion. We were hoping there was
some kind of SQL function that would do it, but that would be too easy!!! :)

Roy.

-----Original Message-----
From: [EMAIL REMOVED]
[EMAIL REMOVED] Behalf Of David Nye
Sent: 11 January 2001 13:53
To: [EMAIL REMOVED]
Subject: RE: FN-FORUM Randomise Recordset in SQL7


Not sure if there is an SQL function, but I normally get recordset of
appropriate type in fixed order, determine number of records (first
recordset access), generate randon number between 1 and max record, go
straight to that record number (second recordset access).

David Nye
http://dnye.com
Business Systems, Database & Internet Applications Design & Development.
Microsoft SQL Server, Access, ASP & VB Programming.


============================================================

* Free listing for freelancers
* Free to advertise jobs
* Free jobs distribution service
* Free database of 1000 freelancers

Freelancers and Freelance Jobs
http://www.freelancers.net

To post to the Forum:
[EMAIL REMOVED]

To unsubscribe please email:
[EMAIL REMOVED]

If you have difficulties unsubscribing please email:
[EMAIL REMOVED]

To subscribe to the digest for this list or for further information please
visit:
http://www.freelancers.net/forum.html