Cannot resolve collation conflict for equal to operation
 

Que tal un saludo a todos, tengo un problema que me esta volviendo loco.
quiero hacer un left join entre 2 tablas de la misma base de datos y me da el error de "Cannot resolve collation conflict for equal to operation" aqui les pongo la consulta:

SELECT his_date, his_tour_id, procesado, sales_ctr_id, tsc_name, pareja, emp_id, emp, fk_config
FROM (SELECT dbo.tbaHis_Tour.his_date, dbo.tbaHis_Tour.his_tour_id, dbo.tbaHis_Tour.procesado, dbo.tbaHis_Tour.sales_ctr_id, dbo.tbaHis_Tour.tsc_name,
dbo.tbaHis_Tour.pareja, dbo.tbaHis_Employee.emp_id, dbo.tbaHis_Employee.emp, CONVERT(VARCHAR(50),
'comision,' + dbo.tbaHis_Employee.fk_tsr_role_name + ',' + CONVERT(varchar(50), dbo.tbaHis_Tour.sales_ctr_id)) AS fk_config
FROM dbo.tbaHis_Tour LEFT OUTER JOIN
dbo.tbaHis_Employee ON dbo.tbaHis_Tour.his_tour_id = dbo.tbaHis_Employee.fk_his_tour_id
WHERE (dbo.tbaHis_Tour.his_date = CONVERT(DATETIME, '2008-02-10 00:00:00', 102)) AND (dbo.tbaHis_Tour.procesado = 1) AND (dbo.tbaHis_Tour.pareja = 1) AND
(dbo.tbaHis_Employee.fk_tsr_role_name = 'TO' OR
dbo.tbaHis_Employee.fk_tsr_role_name = 'Main Line Rep')) AS p

Hasta aqui me devuelve perfectamente los datos que necesito pero cualdo quiero hacer un JOIN con otra tabla de la misma base de datos es cuando me aparece el error:

SELECT P.his_date, P.his_tour_id, P.procesado, P.sales_ctr_id, P.tsc_name, P.pareja, P.emp_id, P.emp, P.fk_config, dbo.tbaConfig.Valor
FROM (SELECT dbo.tbaHis_Tour.his_date, dbo.tbaHis_Tour.his_tour_id, dbo.tbaHis_Tour.procesado, dbo.tbaHis_Tour.sales_ctr_id, dbo.tbaHis_Tour.tsc_name,
dbo.tbaHis_Tour.pareja, dbo.tbaHis_Employee.emp_id, dbo.tbaHis_Employee.emp, CONVERT(VARCHAR(50),
'comision,' + dbo.tbaHis_Employee.fk_tsr_role_name + ',' + CONVERT(varchar(50), dbo.tbaHis_Tour.sales_ctr_id)) AS fk_config
FROM dbo.tbaHis_Tour LEFT OUTER JOIN
dbo.tbaHis_Employee ON dbo.tbaHis_Tour.his_tour_id = dbo.tbaHis_Employee.fk_his_tour_id
WHERE (dbo.tbaHis_Tour.his_date = CONVERT(DATETIME, '2008-02-10 00:00:00', 102)) AND (dbo.tbaHis_Tour.procesado = 1) AND (dbo.tbaHis_Tour.pareja = 1) AND
(dbo.tbaHis_Employee.fk_tsr_role_name = 'TO' OR
dbo.tbaHis_Employee.fk_tsr_role_name = 'Main Line Rep')) AS P INNER JOIN
dbo.tbaConfig ON P.fk_config = dbo.tbaConfig.Config
Aqui es cuando me sa ese error. Yo no veo porque me aparece esto si los dos campos son tipo varchar 50.

Agradezco de antemano

Buenas

El error se debe aque la "colletion" de las dos tablas o de los campos por los que realizas join no son identicos. Revisa en las tablas la propiedad "collation" y en los campos.

Un saludo.

cambiar el collation de todas las tablas
 

visita este blogg talves te ayude el articulo publicado:

www.karen-suzely.blogspot.com

:):D:rolleyes::p