I am trying to join two tables, from separate databases, in a query. They have different collation types. The main DB has the collation: SQL_Latin1_General_CP1_CS_AS
The DB that I want to join to has the collation: SQL_Latin1_General_CP1_CI_AS
I get this error when I try and run without collation (obviously):
Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CS_AS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation.
I am a stranger to collation, so I do not know what to do. If I remove the aspects of the second DB from the query, it runs instantaneously. Once I bring the join into play, the query runs for an hour+ with no results.
Please let me know if you need more context.