Hi,
This error is due to string concatenation collation conflict which means that columns
Nit_Proveedor
and
nombre_proveedor
have different collation (must have the same collation here). You have a couple of options:
1. Change one column's collation to be the same as other's.
2. Specify collation in the select statement:
SELECT Nit_Proveedor + ' - ' + nombre_proveedor COLLATE DATABASE_DEFAULT as Proveedor
FROM proveedor
(instead of
DATABASE_DEFAULT
you can use a specific collation like
Latin1_General_100_CS_AS
)