I've never used it and therefore don't...

Dead right about Power BI and source control. It feels like MS never anticipated that Power BI reports would need to be subject to source control.

There are third-party apps out...

Solid logic.

I had not realised until now that it was possible to...

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, 2 months ago by Phil Parkin.
• This reply was modified 2 years, 2 months 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, 2 months ago by Phil Parkin. Reason: Fixed code - had missed the CREATE TABLE