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 |
|
godspeedba
Yak Posting Veteran
90 Posts |
 Posted - 2009-10-23 : 06:35:57
|
| UPDATE aSET a.surname = (Select top 1 tb_owner_email.email_surname FROM tb_owner_email where tb_owner_email.email_email = a.email)FROM @item_table aThis brings up the message -Cannot resolve collation conflict for equal to operation.Basically I am trying to update data in @item_table on an email address in tb_owner_email. There however might be multiple entries of the same email address in the tb_owner_email. Cannot help but think I am trying to use the wrong method |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-10-23 : 06:54:53
|
1. FROM @item_table won't work without dynamic sql. So you're not showing the real statement?2. error message on collation conflicts always shows mor information - where it is?
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
senthil_nagore
Master Smack Fu Yak Hacker
1007 Posts |
Posted - 2009-10-23 : 07:12:04
|
| Try like this... UPDATE a SET a.surname = e.email_surname from @item_table ainner join tb_owner_email e on a.email=e.email_emailSenthil.C------------------------------------------------------[Microsoft][ODBC SQL Server Driver]Operation canceledhttp://senthilnagore.blogspot.com/ |
|
|
|
|
|
|
Cannot resolve collation conflict for equal to ope