Hi Sam,

Is the use of multiple statements in the stored procedure required because many different tables are targeted by the updates?

I ask because if a single table is the target of the update, it may be possible to perform the query, calculations and update as a single query and hence a single transaction.