Brian Dunning <[EMAIL PROTECTED]> wrote on 10/24/2005 01:32:43 PM: > I got it to work - turns out it was a stupid typo on my part (hate it > when that happens - and hate wasting the list's time even more!). How > long does this temporary table persist for - just the execution of > the one page, or will it live on the server (using resources) until I > explicitly make it go away? >
Temp tables and user variables are connection specific. They will be there until you explicitly get rid of them OR your connection closes. Shawn Green Database Administrator Unimin Corporation - Spruce Pine