why do you need to insert the values into the same table? it does seem like a bad design to me.

may be you should try to insert the values into another table.