I was trying to insert dummy data in database for testing purpose and to match relationship I need to update all id's of one table according to the values of another .

The query I am trying to execute is 

```
update LG set BatchID=(SELECT TOP 1 BatchID FROM Batch
ORDER BY NEWID())

```

but BatchID of LG is filled with only one value seems its caching results of inner query ,how to force it not to do caching of subqueries.