Thank you.That managed to resolve the bulk of the issue and by doing a CTE I managed to get the AVG

WITH OS AS(SELECT Year = DATEPART(yy,SignalDATE)

Hi Luis

The ordering is not important and if it be I will set in in an ORDER BY clause.For now though I am interested in how i could...

The data is importing as the last line had to be changed to

From @x.nodes('/status/CustomerDeposits/*') PropertyFeed(P)

Now my issue is how can I get my sql script to reconcile on the...