Search:

I was thinking about this today. Perhaps a temporary table is worth considering? Create a temp table, insert the sender/receiver/amount, two updates to the company table as above then finally...

I'm sure there is a way to combine the two statements (above my paygrade, perhaps someone else can help) however I fail to see the advantage. They are two discrete operations and should probably be...