I only simplified the SQL to bring the point across. The real SQL is actually much more complex and I do think a CURSOR is necessary as every entry in...

Yes, this is odd behaviour indeed. I tried using varchar() instead of '&' and '', but that did not solve the problem. I even tried replacing '' with something that...

I finally found a solution to this problem. You see it was easy to do the DELETE from the server containing the linked server to the Oracle DB. The problem...

I can insert into this table using an INSERT OPENQUERY. The only problem...

Thanks HowardW, the OpenQuery did the trick!

Thank you for your reply.

I have now tried joining the result set of style id's from the temporary @Style_IDs table but it did not work. I also tried inserting the...

Ok, well maybe if I post the exact queries I'm using you'll be able to spot something I didn't.

Query1:

DECLARE @Style_IDs TABLE (

style_id char(12))

INSERT INTO @Style_IDs (style_id)

SELECT DISTINCT(purchase_order_plan.style_id)

FROM TBL_RANGE_ASSORTMENT_PLAN assortment_plan

...

Thank you for your replies.

I did run the estimated execution plans and it is clear that 100% cost is going into the remote query and must be the reason for...