After resolving a @variable table JOIN issues, I was trying to JOIN usernames between two different databases when up pops a big:
Cannot resolve the collation conflict between "Latin1_General_CI_AS_KS_WS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation.


Pinal Dave to the rescue again:



Yup, when joining two databases, you may have to use: