battula.praveen (3/29/2010)
See this small example and check that helps.http://praveenbattula.blogspot.com/2009/05/how-to-generate-random-numbers-in-t-sql.html
The only problem with that is that it uses RAND() alone and is good for only one row at a time.
--Jeff Moden
Change is inevitable... Change for the better is not.