I get the following error when I run the query pasted below it. As you can
see, I'm not referencing anything called 'Col1047'. I'm thinking this is a
linked server issue but I'm really lost as to how to resolve it as the query
isn't particularly complicated.
Just as an aside. This error is the actual error returned by this query.
The original query involved about sixty different columns so, just out of
curiosity, I cut it down to the six columns you see below. The only
difference in the error message between the 60+ fields version and this one