Home Forums SQL Server 2008 SQL Server 2008 - General Msg 468, Level 16, State 9, Procedure "procedurename", Line 129 Cannot resolve the collation conflict between "Latin1_General_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation. RE: Msg 468, Level 16, State 9, Procedure "procedurename", Line 129 Cannot resolve the collation conflict between "Latin1_General_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation.

  • September 19, 2013 at 5:16 am

    #1651443

    Hi guys,

    I'm have same issue:

    Msg 468, Level 16, State 9, Procedure RPT_MTX_CDR_CostBreakdown_PerMsisdn, Line 142

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

    I have the query below and my error massage is pointing at Line 142 and Line 142 is the SELECT DISTINCT.Please assist.

    Select distinct ---------line 142

    aa.Msisdn,

    bb.box_no

    into #MSISDNUnit

    from #AllMSISDNCost aa

    left join [10.24.4.56\EGHI].wasp_administration_SS.dbo.z_Unit_Lookup bb

    on aa.MSISDN COLLATE DATABASE_DEFAULT = bb.MSISDN COLLATE DATABASE_DEFAULT

    where bb.msisdn in (Select distinct msisdn from #AllMSISDNCost)

    order by bb.box_no--24202