I have two separate procedures. One procedure alters the existing table with new columns. The other procedure adds data to the tables. They aren't being executed, only created. When I hit run, the procedure that adds data to the columns throws an error saying the column does not exist. I understand that it's not created because I didn't exec the procedure that contains the altered code. Not sure why the code inside the procedure executes since I thought that it only creates the procedure.

Some of the code is repetitive and I understand. This is simply to get a working solution before modifying it dynamically.

[![Alter Table procedure](https://i.stack.imgur.com/bIUGl.png)](https://i.stack.imgur.com/bIUGl.png)

[![enter image description here](https://i.stack.imgur.com/trFfd.png)](https://i.stack.imgur.com/trFfd.png)