Hi:

Here is a scenario and I need to know where is the best place to put a begin transaction in a stored procedure:
I have just put some steps of execution below. I would like to rollback any changes made by the inside stored proc but move on to the next fetch from the outside cursor. I am just not sure where I need to place the begin transaction in the inside cursor and outside cursor. Please advise

Bulk insert
Open cursor
--inside stored proc
Call to another stored procedure
for update (this stored proc has a
cursor within it)
Cursor close
Bulk Update


Thanks in advance