Ok, coworker managed to get it to work now it works for me. He didn't do any changes to it. I pasted the code into an email, he copied it out of the email and managed to alter the stored procedure with the code. I'm not going to try and figure this out any more and I'm just going with what I got!

Thanks again, everyone, for your time and expertise. You've all been massively patient with me and I appreciate that as much as I appreciate you working this out for me.