Was coming around to the temp table...

.....brainwave hits..... ...

...... If I put all the data for each campaign into thetemp table then run an insert into sd_rtd_campaigns for each campaign 9simply to put in the name then run an update SQL for each of the calc values using a where sd_rtd_campaigns.Campaignname = temptable.campaignname and then pull from that I get my results......well...thats the sort-of-theory.........

Thanks for your time & input.

Chub..