There are some slow times. Just had the gateway issue myself. Some of this is the load of people running searches. The default system uses FTS and that doesn't scale...

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