i often get this error when trying to JOIN some table
u need to use COLLATION when performing the JOIN, something like this
i found this when trying to JOIN, maybe it affect other areas..until i found one
see u
Cannot resolve the collation conflict between "SQL_Latin1_General_CP850_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation.
u need to use COLLATION when performing the JOIN, something like this
SELECT field1
FROM table1
INNER JOIN table2
ON table1.field3 COLLATE DATABASE_DEFAULT = table2.field4 COLLATE DATABASE_DEFAULT
i found this when trying to JOIN, maybe it affect other areas..until i found one
see u
Comments