IF @DB1 = 'TestDB' USE TestDB
ELSE IF @DB1 = 'ProdDB'  USE ProdDB

To stop the table locking you could use a rowlock hint:

-- Ensure we are using row-level locking
SELECT @intID = (idPool + 1)
  FROM IdConfiguration...

Does your dynamic SQL get executed as one string?

e.g.:

SELECT @ENV = 'USE ' + @DB1
SET @ENV = @ENV + CHAR(13) + CHAR(10) + 'SELECT * FROM myTable;'
EXEC...

To stop the table locking you could use a rowlock hint:

-- Ensure we are using row-level locking
SELECT @intID = (idPool + 1)
  FROM IdConfiguration WITH (ROWLOCK,...

select @uuuImportID,
       1 as hdrid,
       line.value('(abcdefIndex)[1]', 'int') as [Index],
      ...

Deleted duplicate

• This reply was modified 7 months, 1 week ago by  Jonathan AC Roberts. Reason: Deleted duplicate

Here's just one of the many proofs... Both the direct conversion from DATETIME2 to DATETIME and the faulty answer above produce the "silent failures" that I'm talking about". ...

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 8 months ago by  Jonathan AC Roberts.