Hallo Gail.

Unfortunitly I can't post them.

But in comparing them I see that the 2008R2 Actuel plan is using a loop join and 2014 a Hash Match.

I've used a hint to force a loop.

It is not my final solution, but it does buy me some time and put me back on familiar ground.

Many thanks for your help

Ian