Tilfældigt tal i stored procedure

Prøv med
Set @RANDOM_NUMBER = Round(((@MAX - 1) * Rand() + @MIN), 0)

Et random tal mellem 1 og 10:

Set @MIN = 1
Set @MAX = 10
Set @RANDOM_NUMBER = Round(((@MAX - 1) * Rand() + @MIN), 0)

From BOL:
A common way to generate random numbers from RAND is to include something relatively variable as the seed value, such as adding several parts of a GETDATE:

SELECT RAND( (DATEPART(mm, GETDATE()) * 100000 )
          + (DATEPART(ss, GETDATE()) * 1000 )
          + DATEPART(ms, GETDATE()) )

When you use an algorithm based on GETDATE to generate seed values, RAND can still generate duplicate values if the calls to RAND are made within the interval of the smallest datepart used in the algorithm. This is especially likely if the calls to RAND are included in a single batch. Multiple calls to RAND in a single batch can be executed within the same millisecond, which is the smallest increment of DATEPART. In this case, incorporate a value based on something other than time to generate the seed values.

soma får points :)
simpelt og effektivt.

Molberg, jeg har ikke brug for SÅ præcise randomizing funktioner... den simple indbyggede må være nok.