Invalid column name error showing up in query inside a stored procedure

1

Hi everyone,

I had to add a column into an existing stored procedure so that it would show up in the result whenever the procedure would be executed. I entered the column into the query, please see the screenshot below:

pic1
pic1604×840 120 KB

But for some reason, I'm getting the invalid column name error. Please see below screenshot for reference.

image
image1159×261 121 KB

Any help is appreciated.

Thanks,
Sajeel

2

Before you can add the column to the insert statement - you need to add the column to the table. Has that been done yet?

1 Like
3

2 thread on same question.

4

adding the column was the solution, I didn't realize I needed to do that first. Thanks Jeff!

5

Thank you for the feedback - happy to see this has been resolved.