<div>
You should try using &quot;collate database_default&quot;. In your case it would be something like:<br />
<br />
<br />
Update ##AO_Auction_TTbl1 set &nbsp;OrderAuthByEmailid collate database_default = E.LOGUSER_MAIL_ID collate database_default<br />
<br />
I can not check that statement here but if you get any more error messages, please try it with:<br />
<br />
Update ##AO_Auction_TTbl1 set &nbsp;OrderAuthByEmailid = E.LOGUSER_MAIL_ID collate database_default<br />
<br />
I hope this is what you need.<br />
<br />
Regards,<br />
Sasa
</div>


You should try using "collate database_default". In your case it would be something like:


Update ##AO_Auction_TTbl1 set  OrderAuthByEmailid collate database_default = E.LOGUSER_MAIL_ID collate database_default

I can not check that statement here but if you get any more error messages, please try it with:

Update ##AO_Auction_TTbl1 set  OrderAuthByEmailid = E.LOGUSER_MAIL_ID collate database_default

I hope this is what you need.

Regards,
Sasa

<div>
I tried both but still the same error<br />

</div>


<div>
<div class="content wysiwyg-content">
<br />
Hi,<br />
<br />
When I try to run my Stored procedure I get the coalation error on the line below:<br />
The error is &quot;Cannot resolve collation conflict for equal to operation.&quot;<br />
Any help will be appreciated?<br />
<br />
Update ##AO_Auction_TTbl1 set &nbsp;OrderAuthByEmailid=E.LOGUS<wbr />ER_MAIL_ID<wbr />
</div>
</div>



Hi,

When I try to run my Stored procedure I get the coalation error on the line below:
The error is "Cannot resolve collation conflict for equal to operation."
Any help will be appreciated?

Update ##AO_Auction_TTbl1 set  OrderAuthByEmailid=E.LOGUSER_MAIL_ID

Colation Error

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.