I don't think it's needed...

I use this query to find the details of the last time a query was run

DECLARE  @SqlIdentifier   nvarchar(100) = 'uniqueBitOfTextInQuery'

SELECT TOP(1) -- 5A6A34DC-C45A-4AC1-80E8-5A65B3BE9F3F
 ...

SQL Server is suggesting you try the following index:

USE [NetDB]
GO
 CREATE NONCLUSTERED INDEX [IX_nsTransactionProperties_1]
     ON [dbo].[nsTransactionProperties]([ToBePurgedDate])
INCLUDE ([DocumentId])

SQL Server doesn’t have statistics for table variables like histograms and density vectors.

It always estimates the number of rows as 1, though I'm not sure if this is true for...

re "for part no XXX708, it selects 3 warehouses with no activity but there are 2 more with recent sales"

I think the initial query I gave you should...

re "for part no XXX708, it selects 3 warehouses with no activity but there are 2 more with recent sales"

I think the initial query I gave you should work:

            
September 10, 2019 at 6:23 pm
            
#3678858

            
            
                                                
        

You just need to add

SELECT fd.Warehouse,
       I.StockCode,
       I.Description,
       fd.QtyOnHand,
    ...

I'm not sure from your description exactly what you are trying to do but a NOT EXISTS clause should do the job for you.

SELECT fd.Warehouse,
  ...

Drew's method is a better more efficient way of getting the data.

If you want to turn it into an UPDATE statement you will need to put the SELECT inside a...

UPDATE x
   SET x.v_i_L_4_d = z.sum_sales_amt,
       x.v_L_4_d = z.sum_sales_items
  FROM [dbo].[test_table] x
 CROSS APPLY(SELECT SUM(w.sales_amt) sum_sales_amt, 
 ...

Has your stored procedure got a loop in it?  If so it would be outputting an execution plan for each iteration of the loop.

Have you tried editing SSIS packages with Notepad++?

You should be able to create one package that you will use as a template, make a copy of it for each table,...

If it's a "poorly written query", why don't you just rewrite it?

I'm not sure how many other queries you do on that table, but if this is the main query you would get much better performance by creating a unique clustered...