See this small example and check that helps.

http://praveenbattula.blogspot.com/2009/05/how-to-generate-random-numbers-in-t-sql.html