SQL Server Error Message :

 

Msg 468, Level 16, State 9, Procedure sp_Sales_Invoice, Line 209
Cannot resolve the collation conflict between “SQL_Latin1_General_CP850_CI_AS”
and “SQL_Latin1_General_CP1_CI_AS” in the equal to operation.

How to resolve :

SELECT Item
FROM Table_A
INNER JOIN Table_B
ON Table_A.ItemA COLLATE DATABASE_DEFAULT = Table_B.ItemB COLLATE DATABASE_DEFAULT

Leave a comment

comments