tt-615680 (4/12/2012)

---

Dear All,

I have a stored procedure and I keep getting the following error message:

Msg 468, Level 16, State 9, Procedure "procedurename", Line 129
Cannot resolve the collation conflict between "Latin1_General_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation.

I looked at the Collation for the Database and it is SQL_Latin1_General_CP1_CI_AS but I don't know what else I need to do to get it working please?


Thank you in advance!

tt-615680 (4/12/2012)

---

Thank you for your reply!

This is part of the stored procedure:
........................
...................
CREATE TABLE Data
(
Total_TY decimal(10,2), --this is where is gives the error
Total_LY decimal(10,2),
variance decimal(10,2)
)

INSERT INTO #Data
SELECT
CASE WHEN ISNULL(ISNULL(Total_TY,0)/ISNULL(Total_LY,1), 0) = ISNULL(Total_TY, 0) THEN 100
WHEN ISNULL(ISNULL(Total_LY,0)/ISNULL(Total_TY,1), 0) = ISNULL(Total_LY, 0) THEN -100
ELSE ISNULL((ISNULL(Total_TY,0)/ISNULL(Total_LY,1)), 0) END AS var
FROM #TYear c
LEFT JOIN #LYear p ON c.countryCode = p.countryCode

What I'm confused about is that when I run the same stored procedure on a different Server it runs fine and the setting for the Collation are the same.

Thank you!

select serverproperty('collation')
select databasepropertyex('tempdb', 'collation')