>I ran your sample and i got this message:
>
>Server: Msg 137, Level 15, State 2, Line 4
>Must declare the variable '@Rand'.

Depending how random you want your random numbers to be, change it to

SELECT CAST((@RandMax - @RandMin) * Rand() + @RandMin AS int)
-- or
DECLARE @Rand real
SET @Rand = RAND( (DATEPART(mm, GETDATE()) * 100000 ) +
   (DATEPART(ss, GETDATE()) * 1000 ) +
    DATEPART(ms, GETDATE()) )
SELECT CAST((@RandMax - @RandMin) * @Rand + @RandMin AS int)