We have a necessity to call the Rand() in a UDF.But as per SQL Server 2000, it refuses to allow the usage of RAND(), as it is non-deterministic.
Hence, we tried by using a stored procedure which has a call to the RAND() and return the subsequent random value.
This again fired back, as there is no provision to call a normal stored procedure from within a function(UDF). As SQL Server allows only functions and extended Strored Procedures to be used.
Is there a way out to get the right stuff.Kindly reply.
HTH
Ramanujam