Ummm... good idea and nice try... but doesn't work to create different random numbers within the same Select. For example, using the eample Select you have with your code....
select dbo.fx_getrandomnumber(500, 300, rand())
FROM dbo.Tally
WHERE N <= 10
... will return 10 identical numbers.
--Jeff Moden
Change is inevitable... Change for the better is not.