Is it Msg 446 Cannot resolve collation conflict for equal to operation? If it's, check Collation Precedence in the BOL.


>select myTableA.chgcode from myTableA ,myTable B where myTableA.chgcode = myTableB.chgcode
>
>(where myTableB is import from excel)
>and I got the following error,.
>无法解决 equal to 操作的排序规则冲突。
>(In English, it seems said "it cannot solve the (equal to) order problem )
>Please help