I am trying to do a monte carlo simulation within SQL
I have a table containing unique product numbers, and what I want to do, is return each product 10'000 times with a random number next to it;
I can return one row for each product with
SELECT
prodmo,
rnd=(SELECT RAND((convert(varbinary, newid()))))
FROM
PriceMoveDemo