February 3, 2012 at 1:39 pm
I'm trying to display the most recent evaluation, but I'm not sure I am doing this correctly. I'm getting the error message: Cannot resolve collation conflict for equal to operation.
SELECT l.Id, e.Pid
FROM Customers.dbo.Lead AS l INNER JOIN
(SELECT MAX(LeadId__c) AS Pid, LeadId__c
FROM Customers.dbo.Evaluation__c
GROUP BY LeadId__c) AS e ON l.Id = e.Pid
Any help would be greatly appreciated.
February 3, 2012 at 1:43 pm
maybe this helps?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
February 3, 2012 at 2:32 pm
That worked! Thank you. I didn't think it would be that simple
February 3, 2012 at 2:36 pm
you're welcome 🙂
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply