ONE: delete from #ReturnTable where AccCode COLLATE SQL_LATIN1_GENERAL_CP1_CI_AS in (select Acc_Code COLLATE SQL_LATIN1_GENERAL_CP1_CI_AS from account ) TWO: delete from #ReturnTable where AccCode COLLATE CHINESE_PRC_CI_AS in (select Acc_Code COLLATE CHINESE_PRC_CI_AS from account )
delete from #ReturnTable
where
AccCode COLLATE SQL_LATIN1_GENERAL_CP1_CI_AS
in
(select Acc_Code COLLATE SQL_LATIN1_GENERAL_CP1_CI_AS from account )
TWO:
delete from #ReturnTable
where
AccCode COLLATE CHINESE_PRC_CI_AS
in
(select Acc_Code COLLATE CHINESE_PRC_CI_AS
from account )