SQL would be my first choice for cleaning data, while it's a powerful tool for querying and cleaning data, it may not be the best choice for performing complex language...

Look at the error message: It...

drop table if exists #temp1;
go
SELECT * INTO #temp1
FROM(SELECT  ProductID,Product, SUM(Amount ) AS TotalAmount,CONCAT_WS('__', IssueName,IssueID)[Issue]
FROM aaa_tempSalesData1
GROUP BY ProductID,Product,IssueName,IssueID) temp
PIVOT( SUM(totalAmount) 
FOR [Issue]
IN...

Hi Jonathan AC Roberts and Phil Parkin,

Thanks for your reply but if i create 2 temp tables how to join in query as there is no column mapping columns...

You could create two temporary tables with fewer columns instead of one table, then just join them in a query or view.

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 2 years, 5 months ago by Jonathan AC Roberts.

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