You should have privs to create stored procedures in a Development environment. If you're doing all this development work in a production environment, then you first need to have to get with the people in control and learn why that's such a very bad idea. Then, write a stored procedure and send it to the DBAs for review and, if they find nothing wrong with the code, they'll deploy it for you.
It can be what you'll call a "slow way of doing things" but it's necessary to protect the production environment. It will also keep you from having to do inefficient hacks like you're trying to do.