In SQL Server 2000,when you have character data stored with different collation sequences, you need to be aware that comparing columns becomes more involved
Columns with the same collating sequences can be compared or joined without any additional considerations
This mainly occurs when the temporary tables have a different collation sequence than the tables in the database.
The solution is to have the tables in the database to be created without any collation sequence. This will enable the tables to take the default collation of the database
