Archives of the TeradataForum
Message Posted: Fri, 26 Mar 2004 @ 16:18:42 GMT
I've got a small command-line utility that uses sampling to do certain tasks. The sampling is always by fraction, never by hard row count. The value of the sample is passed in from the command line.
There are occasions when the sampling needs to be the whole sample, and I'd like to be able to pass that in, but I don't see how. I've tried using SAMPLE 1.00, which is interpreted as asking for one row, and SAMPLE 1.00, 0, which appears not to see the 0.
Any ideas? SAMPLE .9999999999999999999999999 seems aesthetically unpleasant.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 15 Jun 2023|