If you have these as computed columns, then your DDL should explain that.

When you write " if it is in past we expire it meaning stamp it with latest "Stepsetupdate"",...

I'm not sure what happened there. I just answered from a test account and selected Sys.time() and was marked correct. Are you sure you didn't pick sys.gettime()? Can you screen...

I assume you can split the string into a table.

WITH cteString (a)
AS
(SELECT a 
 FROM (VALUES ('X'), ('Y'), ('Z')) x(a)
)
SELECT i.a + j.a + k.a 
FROM cteString...

What is latest, and what is "expiration is latest step date"? You don't have a step date in your data.

It's a little unclear what you are asking for here, and...

Have you tried percentile_disc?

https://docs.microsoft.com/en-us/sql/t-sql/functions/percentile-disc-transact-sql?view=sql-server-2017

I would swear I checked a box, but apparently not. It's Sys.time() (not Sys.Time()), so both items corrected.

I'm not sure the FTC has a general reporting rule. They have rules over health data and there was (maybe law?) a draft on credit agencies, but I don't know...

No  worries, I figured it out. This migration has made me painfully aware of how poorly I sometimes describe things to developers. I'm more empathetic to users struggling to express...

It's compressing line feeds into one, removing blank lines.

When you write that it's not honoring them, I think of lines being combined.  It does honor a line feed, but removes...

OK, I think we have this filed somewhere, but I'll check on it.

Hmm, OK, let me try something.

SELECT *
 FROM dbo.Articles AS a
GO


-- two line breaks before this
-- Test as SallyDev
EXECUTE AS USER = 'SallyDev'
SELECT *
 FROM dbo.Articles AS...

Glad you like it

Can you post an image of what you want this to look like? From your description, it's hard to decide what things you want changed. We added scrolling, so there...

We keep hearing about data breaches resulting from data being exposed on the internet, meaning that a web search could access the data in un-encrypted form. There is more...

The idea of using colors is interesting. It's a gross way of looking at data. Do you color the columns, tables or databases? In our Data Catalog work with customers,...