The temporay table created in SP is destroyed when SP finishes. Otherwise temp tables is deleted at the end of the session. If you're not closing connection than you've to explicitly DROP temp table before creating it again
Sergey, I don't care what the others here on UT say about you - in my book you're alright!!
All jokes aside, Thank you - you've been a great help.