Jeet Verma Total Post:110 Points:776 Posted by Jeet Verma May-04-2013 2:14 AM MSSQL Server MSSQL Server 1 Reply(s) 1238 View(s) Ratings: Rate this: Hi Everyone! I've got a SQL Server table with about 50,000 rows in it. I want to select about 5,000 of those rows at random. I've thought of a complicated way, creating a temp table with a "random number" column, copying my table into that, looping through the temp table and updating each row with RAND(), and then selecting from that table where the random number column < 0.1. I'm looking for a simpler way to do it, in a single statement if possible. This article suggest using the NEWID() function. That looks promising, but I can't see how I could reliably select a certain percentage of rows. Anybody ever do this before? Any ideas? Thanks in advance!