My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Random number on a per row basis
The new RSS feed is here
So you've tried to get a random number on a per row basis however RAND isn't evaluated on a per row basis but on a row by row basis.
However you can try the following,
select abs(cast(newid() as binary(6)) %1000) + 1
... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Random number on a per row basis