declare @i int
declare @j int
declare @phone varchar(20)
set @j=1 select @i=count(*) from LatestLocation
DECLARE L_cursor CURSOR FOR SELECT Phone FROM LatestLocation
OPEN L_cursor
while @j<=@i
begin
FETCH NEXT FROM L_cursor into @phone update LatestLocation set LocationY = 32.009795 - 0.014887*RAND() * 0.7 where Phone=@phone
set @j=@j+1
end
CLOSE L_cursor
DEALLOCATE L_cursor