To resolve collation conflicts like:

Msg 468, Level 16, State 9, Line 135
Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation.

You should surround the ‘=’ with collate database_default

select * from Product p
inner join Sales s
where p.Name collate database_default = s.ProductName collate database_default

Solution found at:

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.