Hi guys,

Sorry for the confusion,

In my 2nd example, because the PolicyNumber is the same (7777) for both records, and neither of the 2 records have a match in Table2, then...

Thanks Dave,

Your suggestion worked beautifully!

But now I am faced with another problem. I want to use the CTE as part of a Merge statement in order to update Slowly Changing...