Originally Posted by coyotemrh

I have an sql routine that is pretty slow. I think the problem is that everytime I run the update, the open is re-establishing the server connection.
Anyway to keep the server connection open? Kind of like a requery command, but requery only refreshes the data as I understand it ...