Thanks Ryan.

A nice concise solution.

Thanks to all for your help.

Good luck,

Colm

Thanks Antonio. You are 100% correct...what I meant to say was:

WHERE NOT (C1.ParentNo = C2.ParentNo AND C1.ParentRev = C2.ParentRev)

I had noticed that earlier but forgot to say. Sorry.

Thanks,

Colm

Hi guys,

Here is my attempt at fixing the problem I found. It's only a snippet of the code in an attempt to keep the post tidy.

Please feel free to...

Hi guys,

Antonio is indeed correct in his assumption. Although I didn't specify it No/Rev is a composite key for both Parents and Children. Jack if you include the...

Thanks guys,

That is pretty much it. I was looking at Ryan's solution and changed the CTE slightly to be more like Jacks to take into consideration the ChildRev.

--Create temporary...