Nope - tried that, but thanks!

Thanks, but this doesn't really help. The OPENDATASOURCE was working, so that isn't the problem. The problem is a file name which contains a fullstop.

Thanks Jason, looks like a good place for info!!

Thanks for your reply, but that hasn't really answered my question .... how do I get the XML results from the SELECT into the variable??

Thanks for all the posts.

Luckily I only need to run this query once a month, but having a separate indexed date column seems the best approach.

Thanks all!

Thanks Jesper, I didn't even spot that one!

That's exactly what I wanted - thanks!

I enjoyed the "urn" joke!

Hi,

Genius!

I've tested it and it works.

Thanks!

Sorry. I did have to change the join to a left outer join.

The default language on the second server was set to English not British English. I guess British English forces the dateformat to a british date format.

Thanks!

That works! Thanks grasshopper!!

Much appreciated.

Thank Farrell!

That's on the right tracks, but not quite what i need - I should of explained more.

I have a table of company names and a child table of previous names....