Yes, well ChatGPT generates its responses one word at a time, using each preceding word and the context of the conversation, including its own partially completed sentences, to...

I haven't got Copilot, but I thought I'd try it on...

Deleted duplicate posting

I haven't got Copilot, but I thought I'd try it on ChatGPT

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 6 months, 2 weeks 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