Alright - so I had some time today to sit down and play with this, attempting use the cursor.. And I choked. I don't use Cursors often, and the ones...

I will do so just as soon as I get back on the task. I have been diverted 85 times since that was my priority 1 task.. Management always has...

Andy - Thank you for both or your links they combined with Ians post have sparked some ideas, so I am off to write the query fresh from a night...

Quite clear in fact. I like both suggestions and thank you. I am not scared of dynamic sql, use it when I have to.. I actually like the Cursor idea...