Hi,
Can anyone tell me why I am getting the following error message and how to solve it for the SQL code below:
Cannot resolve collation conflict for equal to operation.
As you can see, ContactId is the primary Key I always link back to.
Points worth noting.
All tables are in the same database
ContactId has the same field type, field length and collation type in all instances.
I am running this on SQL server 2000 in query analyzer
SELECT (SELECT COUNT(*)
FROM tblcontactprofiles
WHERE contactid = tblcontacts.contactid AND activestatus = 'A') AS Profiles, ISNULL(Surname, '') + ', ' + ISNULL(Title, '') + ' ' + ISNULL(Christian, '')
AS Contact, Surname AS Expr1,
(SELECT MAX(contacttype)
FROM tblcontacttypes
WHERE contacttypeid = tblcontacts.contacttypeid)
AS jobfunction,
(SELECT MAX([emailaddress])
FROM tblemailaddresses
WHERE contactid = tblcontacts.contactid) AS email,
(SELECT COUNT(*)
FROM tblinvestmentplans
WHERE contactid = tblcontacts.contactid) AS investmentplans, LEN(AdditionalResponsibili
ties) / 4 AS AdditionalContactTypes,
CustomerAccountNumber AS Expr2, *
FROM dbo.tblContacts
WHERE (EducationNumber = 3573)
thanks in advance
Start Free Trial
