SQLTeam.com | Weblogs | Forums

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

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:

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

Any help is appreciated.

Thanks,
Sajeel

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

2 thread on same question.

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

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