🙂

Another test here, a partial (or whole) fix is in:

SELECT *
 FROM dbo.Articles AS a
GO


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

This was interesting to me as well when I stumbled on it.

That's how I feel. It's a good first step, and it's a way to start getting businesses to be more responsible. Someone yesterday (Eric Russell) posted that maybe companies should...

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