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 |
|
djokerss
Starting Member
28 Posts |
 Posted - 2004-11-04 : 03:12:13
|
| i've made a sp to generate my report for my app.where it's joining temporary table with existing table in database,for example :create table #tmp_sales (sales_id int ...........insert into #tmp_sales(sales_id...)values(.............here is the last query to show :select a.sales_id,b.sales_name from #tmp_sales aleft join table_sales b on a.sales_id=b.sales_idit's work before. but today it doesn't work and shown error message :"Cannot resolve collation conflict for equal to operation."fyi = i've restore my database to another computer because there's a trouble with the server.thanks before |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-11-04 : 03:20:23
|
| http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=42033--------------------keeping it simple... |
 |
|
|
|
|
|
Cannot resolve collation conflict for equal to ope