quote:

---

Originally posted by godspeedba

Hi friends

Hope you are all well?
I need help with this error message:
cannot resolve collation conflict for equal to operation.
This occurs for the two delete commands at the bottom of the stored procedure but I don't understand what is causing this.



declare @tabledupe table(lrid varchar)
declare @tablerepeat table(lrid varchar)

INSERT INTO @tabledupe(lrid)
SELECT tb_lrproperties.prop_branchref FROM tb_properties left join
tb_lrproperties On tb_properties.prop_postcode COLLATE DATABASE_DEFAULT= tb_lrproperties.prop_postcode COLLATE DATABASE_DEFAULT
WHERE
tb_lrproperties.prop_name COLLATE DATABASE_DEFAULT= tb_properties.prop_name COLLATE DATABASE_DEFAULT


insert into @tablerepeat(lrid)
SELECT prop_branchref
FROM tb_lrproperties
GROUP BY prop_branchref
HAVING ( COUNT(prop_branchref) > 1
)

select lrid from @tabledupe


DELETE tb_lrproperties where prop_branchref in (select lrid from @tabledupe)
DELETE tb_lrproperties where prop_branchref in (select lrid from @tablerepeat)

---