crompnk
asked on
Create random float numbers using a range
Hi,
How can you create random float numbers using a range in tsql?
Thank you
How can you create random float numbers using a range in tsql?
Thank you
DECLARE @Upper float;
DECLARE @Lower float
SET @Lower = 1.2 -- The lowest random number
SET @Upper = 7.6 -- The highest random number
SELECT Round(((@Upper - @Lower -1) * Rand() + @Lower), 0)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Thanks for the grade. Good luck with your project. -Jim