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...

Then use LAG() and maybe ROW_NUMBER().
Any record with a non-null LAG() value will be a reopen.

How far between open/close would count as a "reopen"? You can just use LAG() with a PARTITION to look backwards at the previous records.

So when you created small, medium-sized, large, and ridiculously large TVPs and JSON files and queried them, what did the results look like?

Why not set the collation to case-insensitive instead of doing all those converting to upper case? But without some sample data, and a sample of query parameter values, it's hard...

"Consumable data" means CREATE TABLE and INSERT scripts that people here can copy & paste into SSMS to recreate your problem. If you don't do that, it's very likely you...

Looks like this is the answer:
https://stackoverflow.com/questions/12676747/how-to-get-the-affected-rows-in-vba-ado-execute

Luis,
I don't think that will work. That's why I did the weird REPLACE.
The Prod | 5 and Prod | 1 records split to separate records when they should...

Oh... maybe I figured out what Jonathan was talking about...
SELECT id, [status], p2, REPLACE(ca.Item, '_',' ') AS NewItem
FROM
    (SELECT id, [status], REPLACE(Products,' ','_') p2
    FROM MyData

Yeah... I was having a fit trying to get the formatting etc to work. Does this site not like Edge? (Maybe I should just break down and use Chrome instead?)