Collation conflict between "Latin1_General_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation?
Please assist - Below is my script. Thanks in advance.
from StkItem HOS
right join [DB CT].dbo.StkItem CTS
on HOS.Code = CTS.Code
where CTS.Code is not null
and HOS.Code is null