The stored proc GetSOR_Abstract is specific to your environment, so we can't help in detail.

But it looks like @tempdata is defined with a maximum length of 128 within the definition...

Like this?

SELECT t.n_type
      ,Total = COUNT (1)
      ,a_type = COUNT (IIF(t.d_type = 'a_type', 1, NULL))
  ...

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

Do you have any control over the format of the input file? If you could get them to use a delimiter which will not appear elsewhere in the text (|...

DelimitedSplit8k is a highly optimised string splitter that was written in the days when there was nothing comparable built in to T-SQL. It has since become the de facto standard...

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

Would you please provide your sample data in the form of CREATE TABLE / INSERT statements?

Try this, maybe?

https://www.sqlservercentral.com/scripts/patexclude8k

If len(string) > len(processed string)

you know that 'string' contained 'invalid' characters.

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

If you are hoping for a dynamic solution which does not require you to type in the names of each key, that takes quite a chunk of coding and requires...

This looks like it would work:

https://learn.microsoft.com/en-us/sql/linux/sql-server-linux-configure-power-bi-report-server-catalog?view=sql-server-ver16

OK, I don't know. Can't see anything obvious.

None of the components shown does any direct filtering. Maybe your FOR loop is going wrong somewhere.

Can you post the full Expression definitions for the six variable which have expressions,...

You'll be lucky to get detailed help with this one. If anyone opens up your package, they will no doubt be confronted with validation errors because the data sources are...

Here is the STRING_SPLIT version

SELECT
    jn.Id
,   cid = MAX (REPLACE (IIF(c2.ordinal = 3, c2.value, ''), 'cid:', ''))
,   Id = MAX...

Obviously, this relies on Jeff Moden's splitter, but as you're on 2022, you can also use the native string_split() function.

I've done the first few for you. You should be able to add the others using similar logic.

DROP TABLE IF EXISTS #JSONish;

CREATE TABLE #JSONish
(
   ...

So, you're looking to insert a row with a RefNum as the next numeric number? One straightforward method, as suggested in the forum, is to grab the MAX(RefNum) into...