Hopefully 10 seconds few times a day is a problem on you server!!!!

No, a solution like this is hopefully only on few rows - as mentioned earlier, else change the way to solve the problem. And if my solution runs in 10...

And if you want the seven last?

I will stop here! The focus on which solutions to use is the big difference. My focus will always be a correct and a general solutions. Unless performance is important,...

20 core (8 + 8 + 4) and 64GB RAM, 2 SSD disk.

No, because I do not have a lot of users on my Laptop! But the scripts shows that even when executing with only 3 users, data are not read in...

If the optimizer choose to use tempdb, data is not necessary read in the same order as inserted - the principle of using a heap. In this situation with few...

• This reply was modified 2 years ago by  carsten.saastamoinen.

This is not correct! It is right that there is no sort, but no sort is not the same as data is in the same order as in the string....

And we can see earlier in this post how some people use tally from a function found on the net, because they have learned, that this is the only and...

AC Roberts: you are making one of the classic mistakes!!! You just use a function without testing for a correct solution. ORDER BY (SELECT NULL) does not guarantee order. So...

Most people are still using a version earlier than 2022! So just using the 2022 version to solve this problem is not the right solution - for some developers it...

As expected!!!! On my desk it takes only 14 seconds to process 131,000 rows. Hardly not a statement that will be executed several times every minute or several times every...

-- Finding second last - problems if this should be more generel
DECLARE @Tmp TABLE 
(
SerialNoVARCHAR (500)
);

INSERT INTO @Tmp VALUES
('1232132|2343345435|34543534534534|3344562534'),
('23243|23423432432|34543534534235|3344562534'),
('23243|23|42343|2432|A3454335B|3344562534'),
('23|24|3|2342|3432432|X34545Y|3344562534');

WITH ReverseSN 
AS
(
SELECT REVERSE (SerialNo) AS SN
FROM @Tmp
),
SecondLast
AS
(
SELECT
CHARINDEX ('|',...

• This reply was modified 2 years ago by  carsten.saastamoinen.

But the except version gives a different result than join,  if the table Parts have rows - PartID and FeatureName - that does not exist in PartsDetails. And from the...

• This reply was modified 2 years, 6 months ago by  carsten.saastamoinen.

To clarify. Only columns used in view are affected by schemabound. You can still add, delete or modify the other columns.

USE master;
DROP DATABASE IF EXISTS TestDB;
GO
CREATE DATABASE...