sql-server - 在 Sql Server 中选择总和为 n 的 x 随机数

Question

如何生成 x 随机数以使 sum=n示例:

N=5000 x=5
1- 1500
2- 500
3- 700
4- 1400
5- 900

Answer 1

尝试这个查询:

DECLARE @x int, @N int, @num int
SET @X=5
SET @N=5000

CREATE TABLE #temp (chosen int)

WHILE @N>=0 and @X>0
BEGIN
    SET @num =RAND()*@N
    INSERT INTO #temp (chosen)
    SELECT CASE WHEN @X=1 THEN @N ELSE @num END AS Chosen
    SET @N=@N-@num
    SET @X=@X-1

END
SELECT chosen FROM #temp
DROP TABLE #temp