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 |
|
1sabine8
Posting Yak Master
130 Posts |
 Posted - 2010-02-11 : 03:45:02
|
| Hi, I wrote a Stored Procedure in SQL 2005, it runs perfectly.Then i try to run this stored procedure from a dataset in ssrs2005 but i get the error "cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_general_CI_AI" in the equal to operation".How can i solve it?Thanks in advance |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-02-11 : 03:51:38
|
you can solve it by adding the following clause to both sides of comparison stameentCOLLATE DATABASE_DEFAULTso if your comparison isCol1 = Col2make it Col1 COLLATE DATABASE_DEFAULT = Col2 COLLATE DATABASE_DEFAULT ------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
Collation error