Unanswered: Help--A error about collation conflict
SET EsaItem = ItemClass
FROM #TMPC A,
WHERE A.EsaItem = B.ItemClassCODE
This code is part of my procedure. I always get error--Server: Msg 446, Level 16, State 9, Procedure GetAdjDataFromShipment, Line 282
Cannot resolve collation conflict for equal to operation.
when program execute at this section.
I try to add this statement "COLLATE SQL_Latin1_General_CP1_CI_AS", but it seems not working. I do not know why!