Posted by Ryan on 12/20/05 19:47

Except that it doesn't fully work now........

All of the collations are set the same (SQL_Latin1_General_CP1_CI_AS)
and the error I originally got is now showing. It appears on the
following update statement :

UPDATE #Extract SET
PD1 = (SELECT DV.FIELD_VALUE
FROM
DEALER_SOURCE_DATA_VALUES DV WITH (NOLOCK),
#Max M
WHERE
DV.DEALER_SOURCE_DATA_ID = #Extract.DEALER_SOURCE_DATA_ID AND
DV.FIELD_CODE = #Extract.Line_No AND -- IT APPEARS ON THIS LINE
AS EXCLUDING IT WORKS, BUT FAILS THE LOGIC NEEDED
#Extract.DSD_YEAR = M.MaxYear AND
#Extract.DSD_MONTH = 1 AND
DV.FIELD_VALUE <> 0.00000)

Server: Msg 446, Level 16, State 9, Line 5
Cannot resolve collation conflict for equal to operation.

Columns used (to help explain what I've done)
------------------------------------------------------------------
[Line_No] VarChar(75) in #Extract
[FIELD_CODE] VarChar(10) in DEALER_SOURCE_DATA_VALUES

These should still match and not throw the error I would have
thought......

I've tried the alter database statement just in case it helped, but it
didn't make any difference (as expected).

Maybe I'm just having a bad day, and need a fresh think tomorrow.

Ryan

[Back to original message]