Please be patient and wait 24 hours before assuming people aren't looking at your question. For many of us (in the US), your question was posted in the middle of the night. In my time zone - 2am for the original time and 3 hours later for the bump. Many people still haven't even had the opportunity to see the question yet!
Welcome to JavaRanch! Thank you taking the time to write an elaborate answer. Not everyone has that much time. Sometimes, it's better to write a little than nothing. Campbell did this - he made sure Pavan knew this was a piece of information that is on the internet and Pavan could get a faster answer by searching than waiting for a reply. When done in a nice way (which I think it was), this is a valid response.
You people support each other nicely , which is required .Good
Joined: Oct 13, 2005
Yes, and finding a tutorial which you like on the internet would have been a far more efficient way for you to learn about temporary tables than for us to write about them. I did actually search for tutorials before replying, but didn't find anything I liked.