DECLARE @RandomNumber float
DECLARE @RandomInteger int
DECLARE @MaxValue int
DECLARE @MinValue int
 
SET @MaxValue = 9
SET @MinValue = 0
 
SELECT @RandomNumber = RAND()
 
SELECT @RandomInteger = ((@MaxValue + 1) - @MinValue) * @RandomNumber + @MinValue
SELECT @RandomInteger

CREATE TABLE #tmp(Value INT, CumulativeProbability FLOAT);
INSERT INTO #tmp VALUES
(0,15.0),(1,20.0),(3,25),(4,26),(5,100);

SELECT MIN(VALUE) FROM #tmp WHERE CumulativeProbability >= 100*RAND()

DROP TABLE #tmp;