Actually I figured it out not long after i made the post. I had actually never spent any time with cursors before, and what i needed was to have...

Thanks So Much! That got if figured out. I'm sure i'll still be confused somewhere, but it's help like this that is always appreciated.

Thanks that helped to shorten my proc, but that still didn't fix the problem, or i don't understand. here is the New proc:

DECLARE @loc AS VARCHAR(50)

--Select @loc = zip_code...

Well, I think so. It only seems to happen when certain functions are ran and then try to complete. I think it's a connection setting in the applications,...