Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
dan_coder
Starting Member
20 Posts |
Posted - 2006-07-19 : 08:05:19
|
Hello guys.I have two tables. I'm writing a stored procedure to execute a simple inner join between the two table, but I have this error:Error 446: Cannot resolve collation conflict for equal to operation.The fields used in the join condition are nVarChar(30).Have you any idea?Thanks |
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-07-19 : 08:08:50
|
looks like the collation on both side of the equal sign are different.use sp_help table to view what is the collation of both the tablesand convert from one to another.where t1.col collate <collation name> = t2.col KH |
|
|
Srinika
Master Smack Fu Yak Hacker
1378 Posts |
Posted - 2006-07-19 : 08:16:22
|
Read about collation in BOLandhttp://support.microsoft.com/default.aspx?scid=KB;EN-US;Q325681Go to design view of each table and check for the Collation property of each field used in JOIN. Either u can change both to 1 type ormuch better way is to use asJoin_Field_1 collate database_default = Join_Field_2 collate database_default Srinika |
|
|
dan_coder
Starting Member
20 Posts |
Posted - 2006-07-19 : 08:22:52
|
It's ok!!!!Thank you!!!!!!!!!!! |
|
|
|
|
|