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?

That's used if you delete a variable-length column from a table and want to release the space that...

Hi Phil and Steve I am very sorry about my font size.

my expected result like this

Name        Salary          Salary_rank

Shiva        8000 ...