The weird thing was that we never got an error after the "UPDATE" command fired. It seems as the rest of the SP was ignored except for the RETURN statement, which was getting populated. But, thanks to that little bit of help there, we were able to get by our issues.

Thanks