from ChatGPT

Query Explanation

Given Tables:

SELECT t1.name, t2.name
  FROM Table1 t1
 INNER JOIN Table2 t2
        ...

• This reply was modified 7 months ago by  Jonathan AC Roberts. Reason: reformatted

Have you got an example of the sort of data you'd like to insert?

You could import them all as nvarchar then try to work out where the error is.

You need to have the columns consistent throughout the entire file.

If you want to find the query you could run something like this soon after the problem occurs.

DECLARE @Database sysname = 'Test'-- Specify your database

SELECT DB_NAME(qt.dbid) AS...

Please consider learning standard SQL. We don't have an IFF() construct; that was spreadsheets and perhaps some nonrelational languages. Take the time to write everything out as a CASE...

Have you checked the SQL Server logs?

As someone who used temp table and had a lot of issues with it, I highly recommend start creating table into DB and use it.

TempDB is good only if...

Different users can be...

Different users can be...

This produces the exact same results as Jonathan's query with far fewer reads.

WITH CTE AS
(
    SELECT xp.RBDTYR
      ...

;WITH CTE AS
(
    SELECT DISTINCT
           RBDCTL,
       ...

I uploaded your picture to ChatGPT 4 and asked it to: "Write a SQL Server create table (table name: XXXRE60P) and insert script for this, make sure you...

Have you tried my solution?

;WITH CTE AS
(
    SELECT DISTINCT
           RBDCTL,
  ...

Have you tried my solution?

;WITH CTE AS
(
    SELECT DISTINCT
           RBDCTL,
    ...

OK, try it as a basic aggregate

SELECT    RBDCTL
        , RBDTTC
     ...