Archives of the TeradataForum
Message Posted: Tue, 21 Aug 2007 @ 10:51:51 GMT
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.
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)).
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|