Sorry, been busy with work and had the flu, so I haven't been online last couple days much.

The #tempTable is a table variable so to say. SQL creates it like we told it to, and destroys it when it goes out of scope. You shouldn't have to worry about it at all. Nothing is written to disk or anything from my understanding.

I got the idea from a book that I highly recommend. It is:
http://www.amazon.com/exec/obidos/tg...glance&s=books

Glad to see you got it working, I know it was kind of hard to digest, and I will try to write up a mini tutorial on it sometime in the future to explain it in more detail. Who knows when I would have the time though.