Hi Guys and Gals,
Can anyone help me with this one? Before the lap-top goes across the room.
I'm using MS-SQL-2000 databases both on the same server.
What this is suppose to do is connect my invoice header table to the invoice detail table (this part works) to a link table (this part doesn't work). The link table will then be connected to another table.
I'm getting the following error.
Server: Msg 446, Level 16, State 9, Line 1
Cannot resolve collation conflict for equal to operation.
The only thing that I can think is that the [Omni Sku] field is char(7) and the Produit field is nvarchar(15). But I changed it to match the [Omni Sku] with no success.
Any ideas???
Can anyone help me with this one? Before the lap-top goes across the room.
I'm using MS-SQL-2000 databases both on the same server.
Code:
select *
from OMNIF_A.dbo.[Fact ventes entete] hd
inner join OMNIF_A.dbo.[Fact ventes détail] dt
on (hd.Facture = dt.Facture) and (hd.[Date facture] = dt.[Date comptable])
left outer join SFR.dbo.[Link Table] lt
on (lt.[Omni Sku] = dt.Produit)What this is suppose to do is connect my invoice header table to the invoice detail table (this part works) to a link table (this part doesn't work). The link table will then be connected to another table.
I'm getting the following error.
Server: Msg 446, Level 16, State 9, Line 1
Cannot resolve collation conflict for equal to operation.
The only thing that I can think is that the [Omni Sku] field is char(7) and the Produit field is nvarchar(15). But I changed it to match the [Omni Sku] with no success.
Any ideas???
