MSSQL Collation Conflict
Ever get the following error? Cannot resolve the collation conflict between “Latin1_General_CI_AI” and “SQL_Latin1_General_CP1_CI_AS” in the equal to operation. I had separate databases on different servers that I needed to query off of. In my case, it was a join between a table on the local server and a table …