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 - 2002-02-19 : 13:19:28
|
| Mary writes "In my db; I have selectes the records and created tables for querying.For each table I need to generate a 10% or 35% random return.There is a unique ID as well as a corresponding (sequentially ordered) ID.Do I again create a random ID column for each table and then how do I delect a %.SQL 7.0" |
|
|
nizmaylo
Constraint Violating Yak Guru
258 Posts |
Posted - 2002-02-19 : 14:15:53
|
| There are a few article on this site about selecting records randomly.Just type random in the search.Article 100 Multiple Random Records w/Single Select on 10/4/2000 100 Returning a Single Random Row on 9/27/2000 100 Returning Rows in Random Order - Part III - Practical Applications on 9/12/2000 100 Returning Rows in Random Order - Part II - Revenge of the Randomizer on 9/11/2000 100 Returning Rows in Random Order on 8/7/2000 83 Another Random Record Selection Method on 1/6/2002 16 Partitioning Databases in an Application Service Provider Model on 9/21/2000 rated 5.0 (1) 16 SQLTeam.com: The First Birthday on 6/25/2001 rated 5.0 (2) 16 Numeric Primary Keys on 6/13/2001 rated 4.5 (2) 16 Creating a Sequential Record Number field on 9/25/2000 rated 4.0 (1) 16 Dynamic ORDER BY on 1/22/2001 rated 4.0 (3) 16 Benchmark Software for Microsoft SQL Server on 8/17/2000 16 Error Message when dumping to hard drive backup device on 7/12/2000 helena |
 |
|
|
|
|
|
Provideing survey data for random sampling