> If you happen to use, say, hmmm, Oracle, there is a handy 'sample' > clause: > > select * from emp sample( 10 ); > That's nice! In SQL Server we have to resort to the expensive "ORDER BY NEWID()" technique (Expensive because it results in the server creating a new GUID for every row) Chris