I am trying to insert records into the same table I am using as the source table. When I run the procedure it shows it completed successfully but there are no rows added to the table, any thoughts?
Possibly your insert statement did not add any row, but ran correctly. Is it possible your insert statement did not select any rows to be inserted? What does your insert statement looks like?