Thanks for the response.

Unfortunately, the person who coded the queries does not use transactions becuase they are convinced that they are only reading data and so will not cause any...