error when merging tables

[kcantor]

Any help on this particular error? I don't sql. 

DataSource.Error: Microsoft SQL: Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_100_CS_AS" in the equal to operation.
Details:
DataSourceKind=SQL
DataSourcePath=kt-sql01;RptViews
Message=Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_100_CS_AS" in the equal to operation.
Number=468
Class=16

[ankitpatira · Accepted solution]

@kcantor This error is common sql database issue when joining different objects for which you cant change collation type. Use either of below queries to overcome collation issue. 

Select * from A join B on A.text = B.text COLLATE Latin1_General_CI_AS

or

Select * from A join B on A.text = B.text COLLATE DATABASE_DEFAULT

[kcantor · Accepted solution]

Simple work around is to add an index column.

[ankitpatira · Accepted solution]

@kcantor This error is common sql database issue when joining different objects for which you cant change collation type. Use either of below queries to overcome collation issue. 

Select * from A join B on A.text = B.text COLLATE Latin1_General_CI_AS

or

Select * from A join B on A.text = B.text COLLATE DATABASE_DEFAULT