Posted by Yas on 06/27/07 10:17

Hello,

I currently have Table1 and View1.

View1 is a query from 2 or 3 tables that works fine on its own.

However in my current query if I try to use it...something like...

SELECT a.col1, a.col2, a.col3, b.col1, b.col2, b.col3
FROM View1 a JOIN Table1 b on a.col1 = b.col1
WHERE a.col2 <> b.col2 OR a.col3 <> b.col3


It throws an error "Server: Msg 446, Level 16, State 9, Line 1 Cannot
resolve collation conflict for not equal to operation."

Clearly I need to use collation between Table1 and View1, But I dont
know where I need to use "COLLATE SQL_Latin1_General_CP850_CI_AI" and
how? this is the collation set on Table1.


Thank you!

Yas

• Next in forum: Re: sql Cannot resolve collation conflict equals - comparing rows and fileds between Table1 and View1
• Prev in forum: Re: Strange performance issue with UPDATE FROM
• Thread view: sql Cannot resolve collation conflict equals - comparing rows and fileds between Table1 and View1

[Reply to this message]