With this query:

;WITH fn as
(
    select N
      from dbo.fnTally(0, 300) fn
)
SELECT dd.PROJECT, dd.HOLE_ID, fn.N + 0.0 DEPTH_FROM, 
 ...

I'm not the OP. The UDF (dbo.fnTally) is a well know one by Jeff Moden and the OP is using this in his original post.

The...

It's nothing to do with the cursor, it's how table variables work. Despite being declared within a block,...

Not sure exactly what you want, but maybe something like this?

Create some data:

-- Creating the table
CREATE TABLE DrillingData (
    PROJECT NVARCHAR(50),
 ...

Not sure exactly what you want, but maybe something like this?

Create some data:

-- Creating the table
CREATE TABLE DrillingData (
    PROJECT NVARCHAR(50),
   ...

I'm not sure I quite understand, but maybe something like this:

INSERT INTO dbo.[table1] (ProductCode, ProductionDate, SerialNumber)
SELECT 'A' + RIGHT('00000' + CAST(CAST(RIGHT(MAX(ProductCode), 6) AS INT) + ROW_NUMBER() OVER...

deleted, duplicate

from ChatGPT

Query Explanation

Given Tables:

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

• This reply was modified 8 months, 2 weeks 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...