Something like this ? ...

with cteRand

as

(

Select top(1000) abs(checksum(newid())) as Rand

from sys.columns a cross join sys.columns b cross join sys.columns b

)

Select *

from <yourtable> cross join cteRand