I am trying to write a stored procedure to add a county field in my reporting services project. I have attached my sp I am working on, but I am getting an error that IMS.County can't be bound.
Please review my sp and let me know what I am missing?
I am working out of one database called db.IMS. IMS has the County, Inmate, and Incarceration tables inside this database. I am trying to pull County from the County table so it will show in my report.
I am creating a temporary table called FinalData. Please review my sp and the table descriptions and tell me what I am doing wrong and what I need to change to get the county to pull?