Need help with SP

[Danny Ni]

Hi,

I was asked to create a SP that will return 7 random numbers from a range of
numbers. SP should take 3 parameters: MinValue, MaxValue and InitialSeed.
If and only if all 3 parameters are the same, the same 7 random numbers
should return.

I have done something so far, just don't know if this is the right way to do
it. Please take a look and I appreciate any suggestions.

Alter Procedure dbo.spRandom7
(
@MinValue int
, @MaxValue int
, @InitSeed bigint
)
AS
BEGIN
Declare @CurrValue int
Declare @MaxLoop int
Declare @CurrLoop int
Declare @SeedDelta float
Declare @CurrSeed float
Declare @Selected int
Create Table #SelectedNumbers
(Value int)

Set @MaxLoop = 100
Set @CurrLoop = 1

Set @CurrSeed = Cast( @InitSeed As Float)
Set @SeedDelta = Cast ((@InitSeed / @MaxLoop) As Float)

Set @Selected = 0

While (@MaxLoop >= @CurrLoop And @Selected < 7)
Begin
Set @CurrValue = @MinValue + Round( (@MaxValue - @MinValue) *
Rand(@CurrSeed), 0)

If Not Exists(Select * From #SelectedNumbers Where Value = @CurrValue)
Begin
Insert Into #SelectedNumbers Values(@CurrValue)
Set @Selected = @Selected + 1
End

Set @CurrSeed = Cast( (@InitSeed - @CurrLoop * @SeedDelta) As Float)

Set @CurrLoop = @CurrLoop + 1

End

Select * From #SelectedNumbers

END