Hello, 

Thanks for the responses everyone! So I got the go ahead from the parent company to create a utility function to use the sp_executesql however when I test...

Preaching to the choir sgmunson! LOL Just wondering if there's a better way than parsing it all out....

Thank you so much for the quick response DesNorton!  However, I should have mentioned, in the environment I'm working in, I'm not able to use SP_ExecuteSQL. Do you know of...

Hi Gail, 

Here's the code - please don't judge me on the syntax - I didn't write this! LOL I've been trying to clean up the mess but you...

I'm so sorry - boy I'm messing this post up - so sorry! trying to do too many things at once LOL  below is the code for the triggers that...

sorry - yes the triggers call those procedures

You're right Gila! I missed a part of the table name when manually updating the code - here's the code with "Dummy" added 

declare @x int

Hi Jacob, sorry! Guess I could have done that at the beginning - here's the updated screen shot. I updated the names after running the code so that I could...

Hi Thom, Thanks for your response! However, the only reason I blacked out some of the table path is due to company policy as the server and database names have...

Thanks Chris! That is much better for all (code and plan and statistics)! 🙂

Ok, so I figured it out in case anyone else comes across this post LOL 
the last line of the Where clause for Outer Apply L should be 

Thanks for the replies! Turns out that the reason was I was using Multi-valued parameters and I just "assumed" that when flagging that checkbox that it told the Report to...

So I really shouldn't post anything so late at night LOL As soon as I clicked the Post button I realized I was trying to pass in an empty string...