OK, I see a bug here. Even though it says I'm unsubscribed, I've gottne emails.

Failed a high priority bug here.

We have a bug filed for this item to ensure that when answers change, users are marked as correct. The points and correct/incorrect will get sorted here (soon, I hope).

I would follow Chris M's strategy. Why check for the constraint? Look for the data.

Maybe use a checksum + some other value in the row? A PK perhaps?

Hmm, I'm not sure what you're doing. If I go to a post by Jeff, and I click " follow" under his name/rank/points, I see this:

That's interesting. The idea that you need a license to collect personal data. That might help ensure startups think about this stuff early. Right now a new company is essentially...

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