BTW... the documentation for the subject of "trailing blanks" NOT being included in comparisons is a bit difficult to find.  You would think that MS would have...

The maximum number of columns in a query is 4096 so you couldn't query 7000 columns.

Would be good if you could go into a bit more detail about what is...

How do you persuade your wife to...

BTW... the documentation for the subject of "trailing blanks" NOT being included in comparisons is a bit difficult to find.  You would think that MS would have included it...

Sorry but the "correct" answer is wrong. The insert into Numbers is:

SUBSTRING( gift, 1, CHARINDEX(' ', td.gift)) = n.word

Will fail for the first row because SUBSTRING( gift, 1, CHARINDEX('...

Yes, the 2nd is what I have asked.

But the replace

DECLARE @String NVARCHAR(MAX) = N'Lorem DO ipsum BE dolor BO sit amet, consectetur adipiscing elit'
SELECT * 
FROM...

Are you saying it returns rows if you uncomment that line?

If so that doesn't seem possible as adding an AND will just increase the constraints on the query so it...

There is a scoped configuration that can be set in SQL 2019 to improve the performance of scalar UDFs:

To check its value:

select * from sys.database_scoped_configurations

I've just pasted in my results in my last comment above. Your results are very different to mine.

I thought Microsoft made a change in a previous release of SQL Server...

--20 seconds, new function
SELECT
    B.ID,
    (SELECT VALUE FROM dbo.[GetValueInLanguage2]('fr', D.XmlValue))
FROM #Big B
INNER JOIN #Dict D ON D.ID = B.DictID

--53 seconds,...

• This reply was modified 2 years, 8 months ago by Jonathan AC Roberts.

It should yield three rows as it groups by [claim ID], [Claim status] and you have (A, P),...

SELECT [claim ID], [Claim status], MIN([Rec Start]) [Rec Start], MAX([Rec End]) [Rec End]
  FROM MyTable
 GROUP BY [claim ID], [Claim status]

In the "Complex" example you have...

Hi folks,

Some words about this interesting function.

Now I call this function like this:

SELECT *FROM dbo.STRING_SPLIT(N'Lorem DO ipsum BE dolor BO sit amet, consectetur adipiscing elit', N'DO');GO

But what to do...

I've tried all those queries and they all run in about 4 seconds on my machine even the one that runs in 76 seconds on your machine.

I'm using SQL 2019...

Fascinating discussions, but what was "wrong" with my solution? I heard stuff like it is not usable except on SQL 2022, but this IS the SQL 2022 forum, is...