No disagreement with specifying a seed causes a deterministic value

How about this?

Set Nocount On

Create Table #Temp

(

Val int

)

Insert Into #Temp values (1)

Insert Into #Temp values (2)

Insert Into #Temp values (3)

Insert Into #Temp values (4)

Insert Into #Temp values (5)

Set Nocount Off

Select Rand() From #Temp

Drop table #Temp

Should this be "Deterministic"?

Can I tell which value will be displayed FIRST? - No

Can I tell which value will be displayed SECOND - Yes, same as first!. To me, this is deterministic.

Output, for those that didn't try:

----------------------

0.293249400409258

0.293249400409258

0.293249400409258

0.293249400409258

0.293249400409258

(5 row(s) affected)

So seems like "Depends on Definition" to me