Thanks Greg,

That works really, well and I'll just add in the decile range valeus to the output now - great !

Greg

That is a brilliant answer. Mnay thanks as I suspect that's saved me a few days of fumbling around...

Thanks, Greg.

By the way, I can't us MERGE, need a SQL2005 solution.

I mean, do I have to list all those 100 metric fields explicitly, to insert or update ?

Can I try something like INSERT VALUES (B.*) !?

OR

UPDATE SET A.*...

Thanks to you for responding. I am a newbie however, and wonder if a more worked example based on my dataset could be provided - possibly combining both techniques mentioned...