Weeeelll, had a bit of time reviewing the SP & your comments szlamany, I'm still not sure what this gains me ? I've still got to execute a cursor (or alternatively construct 1 - n SP's (1 per table). Even placing the data into a temporary table type variable and exec'ing more calculations on it, the definition of the table would merely bring together raw data from each table into 1 table and without being able to further define what should be in the table for each of the campaigns table the data manipulation would be extensive and I'm not quite sure it would be much quicker...

I do fully agree that the SP breaks all the rules but worse is thedesign in the first place !

Or am I getting the wrong end of this ?

Cheers

Chub.