January 22, 2002 at 2:27 pm
I have a stored procedure that links 2 tables from separate databases (on the same server). When i run it, I get the following error message:
Server: Msg 446, Level 16, State 9, Procedure UP_GET_TRAINING_COURSE_DETAILS, Line 8
Cannot resolve collation conflict for equal to operation.
The particular line(s) causing the error are my join statement:
FROM
HEMP.DBO.tblEmployees EMPLOYEES
RIGHT OUTER JOIN
TAA_TRAINING_COURSE
ON
EMPLOYEES.EmployeePayNumber = TAA_TRAINING_COURSE.TAA_FINAL_APPROVAL_PAY_NO
Does anybody know what this error is indicating? Both databases have the same collations, the same settings and are on the same server, so I can't figure out what the problem is.
Any help much appreciated.
Owen West
Programmer,
Hunter Area Health Service
Owen West
Programmer,
Hunter New England Health
January 22, 2002 at 2:40 pm
This is a long shot... are the collations different on the columns EmployeePayNumber and TAA_FINAL_APPROVAL_PAY_NO?
K. Brian Kelley
http://www.sqlservercentral.com/columnists/bkelley/
K. Brian Kelley
@kbriankelley
January 22, 2002 at 4:08 pm
No idea if Brian's suggestion is wrong. Each column, table, or database can have a different code page/collation sequence.
Steve Jones
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply