InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 06:26:37 GMT20http://www.sqlservercentral.com/Forums/Topic1032921-391-1.aspxCheers that has seemed to do the trickMon, 13 Dec 2010 03:48:24 GMTChancus Spearehttp://www.sqlservercentral.com/Forums/Topic1032921-391-1.aspxSomething like this ? ...[code="sql"]with cteRandas( Select top(1000) abs(checksum(newid())) as Rand from sys.columns a cross join sys.columns b cross join sys.columns b)Select * from <yourtable> cross join cteRand[/code]Fri, 10 Dec 2010 04:08:44 GMTDave Ballantynehttp://www.sqlservercentral.com/Forums/Topic1032921-391-1.aspxI 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 PriceMoveDemoFri, 10 Dec 2010 03:59:34 GMTChancus Speare