Thanks guys, The data is in 6 tables with over 50 million rows so I can't bring them all over to one server. The first 2 answers work so I'll...

Eirikur Eiriksson (10/11/2014)

dcarter 43846 (10/11/2014)

I have a source table with an xml column that I need to query on the nodes and then depending on what data is in the...

I did try to delete this topic as it was a duplicate but couldn't find the button!