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 |
|
pelegk2
Aged Yak Warrior
723 Posts |
 Posted - 2006-03-29 : 01:47:12
|
| i have a subquery like this :select top 100 percent clientid from table1 wheretable1.userinfo='123546' and clientid not in (select clientid from #tmpTable)order by clientid descin the #tmpTable i have : clientid and a column called "datatype"with some rows!the error that i recive is :"cannot resolve collection conflict for equal to operation"what is the problem?thnaks i nadvancepelegIsrael -the best place to live in aftr heaven 9but no one wan't to go there so fast -:) |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-03-29 : 01:52:25
|
Your database's collation and the temp table collation if different.Refer to here http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=42033
KHChoice is an illusion, created between those with power, and those without.Concordantly, while your first question may be the most pertinent, you may or may not realize it is also the most irrelevant |
 |
|
|
pelegk2
Aged Yak Warrior
723 Posts |
Posted - 2006-03-29 : 01:59:40
|
| but the table1.clientid and the clientid from the #tmpTable are fromthe same type - nvarchar(10)Israel -the best place to live in aftr heaven 9but no one wan't to go there so fast -:) |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-03-29 : 02:12:54
|
not data type but collation.execute sp_help table1 and see what is the collation for your column ?And also see what is the default collation of your serverselect serverproperty('collation')
KHChoice is an illusion, created between those with power, and those without.Concordantly, while your first question may be the most pertinent, you may or may not realize it is also the most irrelevant |
|
|
|
pelegk2
Aged Yak Warrior
723 Posts |
Posted - 2006-03-29 : 03:13:04
|
| can i define as part of a create table of type #tmptable is collate using serverproperty('collation') to read the database colletion?Israel -the best place to live in aftr heaven 9but no one wan't to go there so fast -:) |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-03-29 : 03:17:23
|
Did you check out the link that i posted earlier ?
KHChoice is an illusion, created between those with power, and those without.Concordantly, while your first question may be the most pertinent, you may or may not realize it is also the most irrelevant |
|
|
|
pelegk2
Aged Yak Warrior
723 Posts |
Posted - 2006-03-29 : 03:44:09
|
| ow i have solved the problem using the collate as part of the select on the equal operatorand i will checkthe link again for my other question thanks alotpelegIsrael -the best place to live in aftr heaven 9but no one wan't to go there so fast -:) |
|
|
|
|
|
|
|
|
problem with using "in"