Got you. That's basically what I've ended up with but I had been hoping to avoid the clutter of permanent tables. They come with all sorts of overhead where your trying to avoid collision if the process is kicked off by two separate users at the same time. There's things you can do by, for example, attaching a randomly generated id to the table name, but using temp tables would have been neater. Still, the nature of this is such that simultaneous runs are highly unlikely so permys'll to for now.