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