• 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 check performance now.