SQL Random Sampler

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

> SQL Random Sampler

LinkBack

Thread Tools

Search this Thread

Display Modes

#1 (permalink)

01-26-07, 14:21

laxonator

Registered User

Join Date: Oct 2006

Posts: 8

SQL Random Sampler

I have a column containing the days of the year and all I want to do is run a code to pick out 10% of them at random and populate another column (or sheet). I believe the below code would work but I don't even know where to put it or how to run it. If there is an easier way of doing this please someone let me know. Please help me, I know it's probably an easy thing to do. Thanks

Code:

GET
     FILE='C:\whatever.xls'.
FILTER OFF.
USE ALL.
SAMPLE 37 FROM 365.
EXECUTE.

« Previous Thread | Next Thread »

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On Forum Rules

Internet Services

Web Development

Digital Marketing

Consumer Tech