Add new column to stored procedure with nested select statements

I am relatively new at SQL and I have been tasked with adding a new column and a date parameter to a rather complex stored procedure that is used to generate a report BIDS. There are 8 tables and 13 derived tables. I need help with joining the table for the new column that needs to be added. Here is where I am at. I wrote the parameter syntax however I have error on I.LastUpdated and my new column that is named III.ProductStatus doesn't want to render on the query. Can someone help me with how to join this table so that it will render correctly.


yosiasz - Is there anything else i could provide that would help with this?

What's the error and describe the rendering error.