Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jon3k
Starting Member
49 Posts |
 Posted - 2003-11-18 : 17:03:38
|
| I've got a table with a list of names. These people are to give each other gifts. I want to select all the records, randomize them, then assign them to another person in the same table, and save the query. This is in a microsoft access database. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
jon3k
Starting Member
49 Posts |
Posted - 2003-11-18 : 18:44:50
|
| DOH! Sorry, didn't notice it. Thanks :) |
 |
|
|
ehorn
Master Smack Fu Yak Hacker
1632 Posts |
Posted - 2003-11-18 : 20:28:27
|
I say draw the names out of a hat.  |
|
|
|
KnooKie
Aged Yak Warrior
623 Posts |
Posted - 2003-11-19 : 13:23:14
|
| isn't there a Randomize function in Access !?Also an RND function that you might want to look at====Paul |
|
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2003-11-19 : 13:45:26
|
| This is actually, though, a cool SQL problem.What would be a good solution? A set-based solution seems quite difficult.Simply generating a random number using NEWID() or RND() wouldn't do the trick -- how do you line the names up, and make sure you have no repeats ?Let the challenge begin!- Jeff |
|
|
|
|
|
|
Randomize List of Names and Combine