Use DelimitedSplit8K() and then specify the item# you want to return?

Jeff Moden wrote an article about splitting strings and included a UDF to do it. It returns (Value, Position) so...

Like this?

use tempdb;

GO

-- Now i want to order the KEY Column in products table

use tempdb;
GO
-- Now i want to order the KEY Column in products table
CREATE TABLE...

Can you post real table definitions (even partial)?  It's impossible to answer your question with the current level of detail.

Maybe this article will help.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

https://www.sqlservercentral.com/articles/cross-tabs-and-pivots-part-1-–-converting-rows-to-columns-1

Why not use Jeff Moden's DelimitedSplit8K? It returns an Item and the Item's ordinal position. Then you could just insert that into your final table.

Got any sample data for us...

If you grant users execute rights on the schema, then they can access the objects inside it. What are you trying to accomplish by doing this?

Grrr… Can't I edit my posts anymore?

I think the problem I'm having is that I can't get SQL Server to do a case-sensitive search. Not sure what I'm doing wrong.

SELECT...

Did you try using LAG()?

Another weird thing... What's up with the way this version of the forum software counts responses? It looks like it's counting messages in the thread and not responses. In the...

Is it possible to collapse some of the forums like you could on the old version of the website? Super handy to minimize the stuff I'm not currently interested in.

(I...

https://www.daxpatterns.com/survey/

First, I can't really read your pictures. Second, I have no scenario or description of what's going on to compare it to, so sure, it's great. They both are. Knock...

This will split the data:
SELECT col, ds.ItemNumber, ds.Item
FROM #Table t
CROSS APPLY Utilities.dbo.DelimitedSplit8K(col,'-') ds
Then you would have to pivot it. This is most...

Do you mean like this?

SELECT *
FROM (
SELECT soh.CustomerID
    , soh.OrderDate
    , LAG(soh.OrderDate,1) OVER (PARTITION BY soh.CustomerID ORDER BY soh.OrderDate) AS PrevSale
FROM Sales.SalesOrderHeader soh

You can sort inside the partition. (Using AdventureWorks2008R2)

SELECT soh.CustomerID
    , soh.OrderDate
    , LAG(soh.OrderDate,1) OVER (PARTITION BY soh.CustomerID ORDER BY soh.OrderDate) AS PrevSale
FROM Sales.SalesOrderHeader soh
ORDER...