I never did performance tests on this, but I believe the SELECT should be faster. It also has the advantage of creating the temp cursor, so there's no need to bother with the deletion of the temp files, etc.

Vlad

>By the way, I like the other solution of keeping an empty table around for this. That's much better, IMO, than mine.