Error when making queries with two databases: Can not resolve the collation conflict

Question

Error when making queries with two databases: Can not resolve the collation conflict

Navigation

#1 by (1 votes)

2

How can I fix the error:

Can not resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "SQL_Latin1_General_CP850_CI_AS" in the equal to operation.

Query:

SELECT T3.ItemCode,T3.ItemName,  sum(Convert(int,A.VPiezas)) as Cantidad, 
sum(Convert(money, (A.VPiezas)))/sum(Convert(money,(A.VPiezas))) as PrecioU 
FROM OITM T0
INNER JOIN OITT T1 ON T0.[ItemCode] = T1.[Code] 
INNER JOIN ITT1 T2 ON T1.[Code] = T2.[Father] 
INNER JOIN OITM T3 ON T2.[Code] = T3.[ItemCode] 
INNER JOIN [Ventas_catavina].dbo.SVenta A ON T3.ItemCode = Codigo1   
WHERE T0.TreeType = 'T' and T3.ItmsGrpCod in (111)
group by T3.ItemCode, T3.ItemName

sql-server

asked by Elizabeth 02.07.2018 в 19:51

source

1 answer

Convert text to PHP array [duplicated] How to show a local folder image to an "ImageView"

score 1 · Accepted Answer

Try it this way:

SELECT T3.ItemCode,T3.ItemName,  sum(Convert(int,A.VPiezas)) as Cantidad, 
sum(Convert(money, (A.VPiezas)))/sum(Convert(money,(A.VPiezas))) as PrecioU 
FROM OITM T0
INNER JOIN OITT T1 ON T0.[ItemCode] = T1.[Code] 
INNER JOIN ITT1 T2 ON T1.[Code] = T2.[Father] 
INNER JOIN OITM T3 ON T2.[Code] = T3.[ItemCode] 
INNER JOIN [Ventas_catavina].dbo.SVenta A ON T3.ItemCode = Codigo1   
COLLATE SQL_Latin1_General_CP850_CI_AS
WHERE T0.TreeType = 'T' and T3.ItmsGrpCod in (111)
group by T3.ItemCode, T3.ItemName