DJ P
asked on
SQl Server 2008 R2 Collation Conflict when joining two tables
Good morning experts! As I fumble my way around sql I have what I think is a very simple join between a table and a view. Below is my sql statement but when I attempt to run I receive the following error:
Cannot resolve the collation conflict between "SQL_Latin1_General_CP850_ BIN" and "SQL_Latin1_General_CP1_CI _AS" in the equal to operation.
I have zero clue on how to resolve. What am I missing?
select dbo.MasterCostCodeList.Lev el1, dbo.MasterCostCodeList.Lev el2, dbo.MasterCostCodeList.Lev el3, dbo.MasterCostCodeList.Des cription, dbo.MasterCostCodeList.Act ive, dbo.CPtoTCP_ImportB.Projec t,
dbo.CPtoTCP_ImportB.[2nd Level], CPtoTCP_ImportB.[3rd Level], CPtoTCP_ImportB.[Desc], CPtoTCP_ImportB.ORG_ID, CPtoTCP_ImportB.Expr1
From dbo.MasterCostCodeList
inner join dbo.CPtoTCP_ImportB on dbo.MasterCostCodeList.Lev el3=dbo.CP toTCP_Impo rtB.[3rd Level]
where dbo.MasterCostCodeList.Act ive = '1'
and CPtoTCP_ImportB.Expr1 = 'Y'
Cannot resolve the collation conflict between "SQL_Latin1_General_CP850_
I have zero clue on how to resolve. What am I missing?
select dbo.MasterCostCodeList.Lev
dbo.CPtoTCP_ImportB.[2nd Level], CPtoTCP_ImportB.[3rd Level], CPtoTCP_ImportB.[Desc], CPtoTCP_ImportB.ORG_ID, CPtoTCP_ImportB.Expr1
From dbo.MasterCostCodeList
inner join dbo.CPtoTCP_ImportB on dbo.MasterCostCodeList.Lev
where dbo.MasterCostCodeList.Act
and CPtoTCP_ImportB.Expr1 = 'Y'
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER