Here's a SELECT query which does the concatenation. I'm sure that you can change it into a conditional UPDATE.

DROP TABLE IF EXISTS #TableA;

CREATE TABLE #TableA
(
  ...

Just enter some dummy (but valid) values for the parameters and it should work.  SSRS does this when it believes that things have become too complicated for it to guess...

I've read through the question a couple of times and I don't understand what you are trying to achieve.

Can you provide your sample data in consumable format, along with an...

Decide what you want to happen in these cases ... how to 'get around it' will depend on your desired outcome.

Shift all parameters 1.5 bytes to the left and start the run.  In 30ms, stop the run and then restart it.  Note that you have to do this your...

Can you find them here?

https://catalog.update.microsoft.com/search.aspx?q=sql+server

--Edit: remove duplicate post

• This reply was modified 2 years, 3 months ago by Phil Parkin.

Hi,

I have 2 tabs created in SSRS Report.There is calendar Day prompt in the report. By Selecting the Calendar Day Prompt the 2nd tab displayed in the report varies...

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.