I'm also having this problem. It's like (simplified version, that is)

I run one select-insert stored procedures, selecting from table A, inserting into table B, and then updating table A....