Archives of the TeradataForum
Message Posted: Thu, 03 Mar 2005 @ 17:29:38 GMT
Subj: | | Random function with a column value |
|
From: | | Brian.Jones |
Hello -
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
|