https://www.myerrorsandmysolutions.com/cannot-resolve-the-collation-conflict-between-sql_latin1_general_cp1_ci_as-and-latin1_general_100_ci_as-in-the-equal-to-operation/
Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_100_CI_AS"