SQL Server 2005 Data Collation

[#1]

Hello,

I have a problem with data collation... Or at least I think there is a problem.

SQL query returns an error

SELECT *
FROM Table1
WHERE NOT EXISTS (SELECT * FROM View2 WHERE View2.Text = Table1.Text)

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

But the data is loaded and partially joined in QV if I load from each table separately. But I need the data to be fully joined...

The solution would be to change the collation of data during the load... How to do it?

[hector]

Hi, more of a QlikView issue, it sounds to me like a table (or database) problem, in my experience you have to change the collation during the join task (SQL join), and then load the result in QlikView.

Rgds