Create Function to generate list of random numbers in SQL Server

Hi nauna,

Refer below function.

SQL

CREATE VIEW vw_getRANDValue
AS
	SELECT RAND() AS RandValue
GO
CREATE function fn_Random_Number_Generator(@min_integer int, @max_integer int)
returns @rand_digits table 
(
   rand_digit tinyint,
   frequency int
)
as
begin 
    declare @TempTable table (rand_digit tinyint)
    -- declare min and max random digit values
    -- and variables values to control loop count
    declare @loop_ctr int = 0,@max_loop_ctr int = 1000 
    -- loop 1000 times
    while @loop_ctr < @max_loop_ctr
    begin 
        -- generate a random digit from @min_integer through @max_integer
        -- and insert it into @TempTable
        INSERT INTO @TempTable (rand_digit)
        SELECT floor((SELECT RandValue FROM vw_getRANDValue)*(@max_integer - @min_integer + 1) + @min_integer) 
        set @loop_ctr = @loop_ctr + 1      
    end 
    -- count the number of each randomly computed digit
    -- and display the results
    INSERT INTO @rand_digits
    select rand_digit, count(*) [frequency]
    from @TempTable
    group by rand_digit
  
    return
end
GO
SELECT rand_digit,frequency 
FROM dbo.fn_Random_Number_Generator(5,10) 
ORDER BY NEWID()

Screenshot