June 18, 2003 at 8:59 am
I am getting an error when trying to run a query...here is the query and the error...
SELECT a.project_id_, a.building_id_, a.unit_id_,
b.FASTCODE, SUM(a.quantity_) as SumOfquantity_, b.ITEM_NO, b.[DESCRIPTION],
a.po_number_
FROM dbo.CC_Item_List b JOIN
dbo.SpecialOrderPOResources a ON b.FASTCODE = a.resource_id_
GROUP BY a.project_id_, a.building_id_, a.unit_id_,
b.FASTCODE, b.ITEM_NO, b.[DESCRIPTION],
a.po_number_
HAVING Sum(a.quantity_)>0
a few examples of records being joined are...
loinsulfoam
lojczziacc14
lokilz
lomasktape
lomb4x4stndp
Error:
Cannot resolve collation conflict for equal to operation.
Any help is appreciated
June 18, 2003 at 9:13 am
When i received this error it was due to the collation of the two columns i was joining on being different. Check the collation for the two columns you are joining on and make sure they are the same.
Growing old is mandatory, growing up is optional
June 18, 2003 at 9:20 am
Figured it out from one of the articles on this site...thank you!
collate Latin1_general_CI_AS
June 19, 2003 at 9:27 am
FYI: You can get a problem like this is the colation is different on tempdb that your db if you are joining on a temp table.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply