Archives of the TeradataForum

Message Posted: Fri, 04 Mar 2005 @ 16:30:47 GMT


	<Prev	Next>		<<First	<Prev	Next>	Last>>

Subj:		Re: Random function with a column value

From:		Dieter Noeth

Jones Brian wrote:

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.

     RANDOM(1,2000000000) MOD STORE_COUNT + 1 AS MYCOLUMNX

Generic version with arbitrary minval and maxval:

     random(1,2000000000) mod ( maxval - minval + 1) + minval

Dieter


	<Prev	Next>		<<First	<Prev	Next>	Last>>

Archives

2008		2003
2007		2002
2006		2001
2005		2000
2004		1999

2005 Indexes

Jan		Jul
Feb		Aug
Mar		Sep
Apr		Oct
May		Nov
Jun		Dec


	Top	Home	Join	Privacy	Feedback

Copyright for the TeradataForum (TDATA-L), Manta BlueSky

Last Modified: 30 Jun 2008