Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "SQL_Latin1_General_CP1_CI_AI" in the equal to operation.

SET NOCOUNT ON
declare @getFile cursor
set @getFile = cursor for
select a.FormNo, a.ConvertID, a.InputTable, a.OldFormID,
'D:\textfile\LHBU\'+b.nama_file  link
FROM ATI_CONVERT..Convert_Group a
inner join #dir2 b on a.InputTable=b.InputTable
where OldFormID like '3%'
and a.InputTable in ('IN_LHBU403','IN_LHBU401','IN_LHBU402','IN_LHBU407','IN_LHBU404')
Order by formNo, InputTable

F5

Msg 468, Level 16, State 9, Line 8

Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "SQL_Latin1_General_CP1_CI_AI" in the equal to operation.

SET NOCOUNT ON

declare @getFile cursor

set @getFile = cursor for 

--result

select a.FormNo, a.ConvertID, a.InputTable, a.OldFormID, 

'D:\textfile\LHBU\'+b.nama_file  link

--'D:\textfile\LHBU\' link

FROM ATI_CONVERT..Convert_Group a

INNER JOIN #dir2 b 

on a.InputTable collate SQL_Latin1_General_CP1_CI_AI

=b.InputTable collate SQL_Latin1_General_CP1_CI_AI

OR

collate SQL_Latin1_General_CP1_CI_AS

Tweet