Fantastic, that link is perfect! Thanks ever so much, seems to me the more I learn about SQL I realise the less I actually know! I got so lost reading...

That's it! Could I pester you a little about this query?

Where you have at the start With Resolver...are you creating a temp table? There is quite a bit in this...

ChrisM,

Thanks for that, I've got to be honest It's going to take me sometime to get to grips with that and understand each line in full!

I've run it but I...

Hi sorry about that, guess who didn't read the forum guidelines! *blush*

I have changed the schema for this example from using Guids to uising INT for IDs

if OBJECT_ID('Test..Company','U')is not null

drop...

Hi,

Thanks for replying, I must apologise I think I have simplified far too much and thus not covered a point that causes me a problem with the solution you provided...