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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-11-25 : 11:46:15
|
Marius writes "I read your random order articles of Aug and Sep and I need to know the following:
1. How do I create these random order numbers in the table that I want to search in and,
2. How do I automate the generation so that it actually generates new random numbers every day at a specified time.
I also want to know if by generating the numbers in the table once a day, if the actual execution will be faster if I order the result set on the random numbers. ( will sql still generate a temp table to do the ordering or not)
I am very new to SQL so please give me good t-sql examples so i can follow
Thanks
Marius
win 2000, sql 7" |
|
|
|
|
|
random order continued