"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?)

Yeah, like that!

Your sample data is messed up. I removed a bunch of columns so that I had a minimum to deal with. In a word, you need DelimitedSplit8K to do this...

I think you'd have to use LAG() to look at the previous visit for a given patient. Then use DATEDIFF() to get the days between the two dates, and if...

See https://docs.microsoft.com/en-us/sql/t-sql/queries/with-common-table-expression-transact-sql?view=sql-server-2017

See Example D.
USE AdventureWorks2012;
GO
WITH DirectReports (ManagerID, EmployeeID, Title, EmployeeLevel)
AS (   SELECT ManagerID,
       ...

script out all the constraints,
drop them all,
import data,
re-add the constraints by running script from step 1

If you use RIGHT([oldSSN],4) then the rest shouldn't matter, because you'll never get any of the dashes anyway, because they would be 5th from the right.

Got Google?
https://stackoverflow.com/questions/26771966/find-all-ssrs-reports-using-the-same-shared-dataset

Or company attorney, if they have one.

… and if the company gets security audited, that's going to be serious. and expensive.

Wait. I'm confused. You tell which are primary keys and foreign keys by looking at the table definitions. Inner joins vs outer joins - that's a join in a query:...