Are you able to (safely) disable any firewall on the SSRS server and try again?

Your device name column must contain some strings which are not in the format

<make>_<name>_<date>_<time> <am or pm>

My code will error unless there are two or more underscores in the device...

Does this work for you? Not quite what you asked for, but maybe even an improvement.

SELECT DeviceName = SUBSTRING (t.devicename, 1, c2.p2 - 1)
   ...

Please provide your test data in consumable form (ie, with CREATE TABLE / INSERT statements), so that we can paste into SSMS and then help you with your code.

I vote for using the splitter. For some reason, I'd forgotten that even existed when I posted earlier.

Good morning, I don't understand what's going on in my database all tables that have an auto-increment ID will stop auto-incrementing. and I have a message that the code...

Here is a possibility.

You could so it all in a single (rather lengthy) expression, but I broke it out to help you understand how I did it.

Please provide consumable test...

This, maybe?

UPDATE T
SET ACTIVE = IIF(S.user IS NULL, 'N', 'Y')
FROM TARGET T
    LEFT JOIN Stage S
        ON...

• This reply was modified 2 years, 1 month ago by Phil Parkin.
• This reply was modified 2 years, 1 month ago by Phil Parkin.

Is there a covering index on the table being added?

Try running the proc outside of the report & examining the before and after execution plans. That should give you some...

I thought about this too. But this validation needs to be written carefully, also to avoid the...

It's a bit hacky and not as user-friendly, but if you were to create two arguments as follows

@SortColumnCode TINYINT

@SortOrder BIT = 0

and then decode the SortColumnCode number to a column...

Maybe you could switch the logic around a bit?

DECLARE @tocheck INTEGER;

SET @tocheck =
(
    SELECT tocheck FROM #a
);

DROP TABLE IF EXISTS #part;

CREATE TABLE #part(Col1, ...,...

• This reply was modified 2 years, 1 month ago by Phil Parkin. Reason: Fixed code - had missed the CREATE TABLE

Your code does not result in an error, so that explains why the CATCH block code is not executed.

Or is your question 'Why does this code not generate an error?'

• This reply was modified 2 years, 1 month ago by Phil Parkin.

To read data from a DB2 database on SQL Server 2017, you can use the Linked Server feature. First, create a linked server using the "sp_addlinkedserver" system stored procedure....

As Grantor is a column which is specific to your database, no one here is going to be able to help in any detail without additional information.

But, my assumption is...