Hi,
If I have multiple select and update statements in my stored procedure, will it be better to group up the select statements follow by the update statements like follows:
SELECT ...
SELECT ...
SELECT ...
SELECT ...
UPDATE ...
UPDATE ...
UPDATE ...
UPDATE ...
Or, will the performance be better if I will to group the SELECT and UPDATE as a pair like follows:
SELECT ...
UPDATE ...
SELECT ...
UPDATE ...
SELECT ...
UPDATE ...
SELECT ...
UPDATE ...