Good afternoon,

Thank you very much for your help.

I found some problems in the queries and lots of duplicates. I managed to spped up the query from 1 min. 30...

Hi Briandonor,

I attach you the Estimated Execution plan and the number of rows per table.

According to the execution plan the more expensive statement is:

INSERT INTO @Property

Select * FROM OPENQUERY (ingres2,...

Hello guys,

Thanks you for your reply. This is the definition of the sp. The data is taken from a ingress db. Unfotonately I don't have acces to the tables.

CREATE PROCEDURE...