Archives of the TeradataForum

Message Posted: Tue, 21 Aug 2007 @ 10:51:51 GMT

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

Hi Experts,

I need to pass the upperbound value for Random function dynamically. Is there any better way to cater this requirement. Currently am try to generate the SQL regularly instead of having a single SQL to cater this.

eg: Random(1,2500)

The upperbound value 2500 is a varying number which is count(*) from other table (i.e. In simple words my requirement is something like this Random(1, sel count(*) from table)).

Thanks,

Rakesh Saxena.

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