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 |
|
GenerationWithoutName
Starting Member
26 Posts |
 Posted - 2006-01-27 : 01:56:59
|
| Dear All,I have SQL statement like this :...UPDATE a SETa.PrintedDate=b.PrintedDateFROM dbo.t1 AS a INNER JOIN @VarTab AS bON a.NPPNo=b.NPPNo AND a.Period=b.Period...And i got error message like this :Server: Msg 446, Level 16, State 9, Procedure BLA2, Line 43Cannot resolve collation conflict for equal to operation.anyone can help me to solve these error ? ? |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-01-27 : 01:58:35
|
| the collation of both table are different. Create your @VarTab to be same collation as t1----------------------------------'KH' |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-01-28 : 02:34:50
|
| Or force the collation on the comparison in the JOIN etc. where varchar/text/etc. columns are involved(but I agree with khtan that the collation on the CREATE/DECLARE for the temporary table should be your first choice. We ALWAYS put a COLLATE statement on the CREATE/DECLARE for ALL string columns - sure as eggs-are-eggs we'll move the code to a server with a hooky collation at sometime in its life!)Kristen |
|
|
|
|
|
|
collation