Trying to run a query across multiple server with incorrect collation settings
Posted on 2007-10-18
I am trying to run a select statement across a linked server where the join is based on a field of the same type (char) on both databases, but one of the database I believe was setup incorrectly a long time ago and I have no ability to change it
SELECT t1.xxx, t2.xxx, t2.xxx
FROM table1 t1
JOIN table2 t1 on t1.code = t2.code
The error I am getting is
"Cannot resolve collation conflict for equal to operation."
Is there anyway of adding a collation type to the select statement so thay I can compare correctly?
Or is there anything else I can do