مشكل Join با تيبل موقت

[kamran_fa]

دوستان سلام ، مشكل كد زير چيه؟
SELECT SUM(#TempNeed.VNo) AS SVNo,#TempNeed.CODE,TCode.[NAME],TCode.TechnicalCode
FROM #TempNeed INNER JOIN
TCode ON #TempNeed.CODE = TCode.CODE
GROUP BY #TempNeed.CODE,TCode.[NAME],TCode.TechnicalCode

اين خطا رو ميده
Cannot resolve collation conflict for equal to operation.

[محمد سلیم آبادی]

http://blog.sqlauthority.com/2007/06/11/sql-server-cannot-resolve-collation-conflict-for-equal-to-operation/

SELECT SUM(T1.VNo) AS SVNo,
T1.CODE,
T2.[NAME],
T2.TechnicalCode
FROM #TempNeed T1
INNER JOIN
TCode T2
ON T1.CODE COLLATE DATABASE_DEFAULT
= T2.CODE COLLATE DATABASE_DEFAULT
GROUP BY T1.CODE,T2.[NAME],T2.TechnicalCode;