sql server store procedure

Question

Please am trying to insert into two tables in sql server with store procedure but one table get inserted and the other table do not, Please any help will greatly help.