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 1 year, 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...

In a coffin?

A bit harsh!

Despite his clever responses, I don't think he's called Brain 🙂

Mr Brian Gale is correct, I saw no notification. Here is a possible solution – it relies in integer division:

DROP TABLE IF EXISTS #temptable;

CREATE TABLE #temptable
(
 ...

• This reply was modified 1 year, 8 months ago by Phil Parkin.

Can you please complete your question for desired results after

set @setValue=3

?

It sounds like it was generated by ChatGPT or similar – and there would be an issue if that...