I ran DBCC FREEPROCCACHE and the procedure runs now. I am guessing the procedure had a bad execution plan, but on some of the other procedures, the parameters don't...

I am running "exec spname" passing the int parameter, which does not return. The if I script the sp to a query window, note out the Create and declare...