Collation conflict between "Latin1_General_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation?

Hi - I need some urgent help please - I know why the DB is causing the above error - all I need to do is run a select statement to get the value I require. I've written the following statement but I'm not sure where to enter the collation clause? In the select statement or in the join clause?? Please... show more Hi - I need some urgent help please - I know why the DB is causing the above error - all I need to do is run a select statement to get the value I require. I've written the following statement but I'm not sure where to enter the collation clause? In the select statement or in the join clause??

Please assist - Below is my script. Thanks in advance.


(
select
HOS.StockLink
,HOS.Code
,HOS.Description_1
,CTS.StockLink
,CTS.Code
,CTS.Description_1
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
)
Update: Hi - I'm using Microsoft SQL2008 R2.
2 answers 2