I got it. The INSERT INTO was missing the draft status id field and also the name in the new table was still DRAFT_STATUS_ID but labeled Draft Status Id.

The problem is i need to perform this query about 85 times because the value '1001' is different for each entry. What is the right way of typing this SQL query to accomplish the above without having ...