Can you show us the query?

Extra post to flip page

After rereading the original post I now understand about the INTERVAL_THICKNESS, this query works using a case statement to calculate the INTERVAL_THICKNESS

;WITH fn as
(
   ...

However it looks like it is locking on the LITH1 of the 1 meter tally. I need somehow to instruct if there are multiple LITH1 rows within the meter,...

• This reply was modified 2 years, 4 months ago by Jonathan AC Roberts.

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 2 years, 4 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...