In SQL, you can generate random values using the RAND() function, ... The TABLESAMPLE clause allows you to select a random sample of rows from a table or a view.

(this is re: MS SQL 2000)<BR><BR><BR>Our corporate intranet has a Tips section, where we tell users things they should know (or may have forgotten), e.g. how to archive email. We've decided to add ...