Can't remember where I got this script from but it will generate insert statements for all the rows in a table:

To generate inserts from a table just call it something...

CREATE TABLE MyTable (
    ID INT IDENTITY(1,1) PRIMARY KEY,
    Value INT,
    DateTimeColumn DATETIME
);

INSERT INTO MyTable (Value, DateTimeColumn)
VALUES 
...

DECLARE @StartDate datetime = '20221001';
DECLARE @EndDate datetime = '20221031';

SELECT *
  FROM #t1
 WHERE PrgFld LIKE 'BAS%'
   AND PrgVal BETWEEN CONVERT(varchar,@StartDate,112) AND CONVERT(varchar,@EndDate,112);

Try inserting the rows that need to be deleted into a temporary table then another step to delete the rows:

SELECT DEM.NUM_DEM 
  INTO #RESULTS_TO_DELETE
  FROM...

This isn't...

I think the first thing to do is to try to optimise the query to make it run faster as frederico suggested.

ChatGPT is really good at explaining things like that. Just paste the error message into it.

If the index doesn't already exist you need to remove DROP_EXISTING = ON from the index creation or set it to OFF.

• This reply was modified 1 year, 7 months ago by  Jonathan AC Roberts.

It can't... there's no ORDER_ID column in the...

I would guess one or maybe both of these indexes would fix your problem:

 CREATE INDEX IX_c_b_party_comm_1 
     ON dbo.c_b_party_comm(ROWID_OBJECT, COMM_TYP_CD) 
INCLUDE (COMM_TYP_CD,...

Okay I am not understanding your comment "I have a feeling it is taking it literally as a string" -- how else should it take it? I mean you...

try:

 like '%' + p.forenames + '%'

So it it the case that there is an AD account that you can remotely connect but the SQL login cannot remotely connect?

If it works when they remote to the host...