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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-06-28 : 09:49:51
|
| Carlo writes "I'm trying to make an Union query with SQL 2000 where I would combine two queries but I receive this error:Server: Msg 446, Level 16, State 9, Line 3Cannot resolve collation conflict for UNION operation.This because the two queries take data from two differente DB with different collation.How can I bypass the problem?Thanks in advanceCarlo" |
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2002-06-28 : 10:24:13
|
| something like this, maybe:select myname collate SQL_Latin1_General_CP1_CI_AI from tblBunionselect myname collate SQL_Latin1_General_CP1_CI_AI from tblA |
 |
|
|
|
|
|
Union and collation