Is SCCOE_Order_Progression the database you're running all this in? Wondering if there's a trigger on that table inserting into a table of the same name in another DB.

Far-fetched, but so far the symptoms are quite strange. For that matter, probably worth checking for triggers anyway.

Cheers!