Archives of the TeradataForum
Message Posted: Thu, 03 Mar 2005 @ 17:29:38 GMT
How can I use a column value with the random function? For example, I have a table with a column named STORE_COUNT which is an integer with values from 1 to 5.
When I try:
SELECT RANDOM(1,STORE_COUNT) AS MYCOLUMNX FROM ...
I get an 3707 error:
Code = 3707. 3707: Syntax error, expected something like an integer or a decimal number or a floating point number or '+' or '-' between ',' and the word 'STORE_COUNT'. Output directed to Answer set window
Any suggestions? Thank you. -Brian
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|