Either way that i run the procedure it still says that the variable is not found. But if I run it in the command window it will work fine. Any ideas?

Thanks