Hi everybody,
I'm working on an SP and there is some problem I'm trying to figure out the best way to solve.
I'm writing PersonUpdate procedure right now.
Depending on the Person Type this procedure tries to update several tables. I want to wrap the update in the transaction.
All person types update People table with the same code.
The way I coded it right now is this (pseudo-code)
BEGIN TRY
if type = one type
begin transaction
Update People
Update Other tables
commit transaction
else if different type
begin transaction
Update People
Update Other tables
commit transaction
etc.
END TRY
BEGIN TRY
General logic for failure, rollback transaction
end try
I'm wondering if there is a way to somehow move Update People logic to do it only once.
Do you see a way to re-organize this procedure?
Thanks again.
If it's not broken, fix it until it is.
My Blog