Cannot resolve collation conflict for equal to operation

[ocram]

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

[PepeLolo]

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.

[suzely]

visita este blogg talves te ayude el articulo publicado:

www.karen-suzely.blogspot.com