I'm not 100% sure on the nulls. My gut says I shouldn't be passing any values that are nulls, but looks like input table has quite a few in different columns.

Right now I'm trying to make some glaring performance changes until we get time to dismantle the whole process.

2019 isn't an option now. I have dabbled with the in-line table value, but I'm not quite sure how to get rid of the declares.