Thank you so much for your replies. I will certainly look into partioning asap. I have also discovered that removing all the temp table stuff and just using this instead...