Yeah, heavy reliance on the "Statements such as..." in the current documentation.

The SQL Server 2000 documentation was a bit clearer, saying that @@ROWCOUNT is set to 0 by any statement...

Perhaps something like this?

CREATE TABLE #SomeClarionValues (DATEOFACCESS int, TIMEOFACCESS int)

INSERT INTO #SomeClarionValues

VALUES (78439,1),(78439,69087),(78439,40001), (75247,7511378),(75247,8630000)

SELECT

ClarionConvertedToDatetime=DATEADD(MILLISECOND,(TIMEOFACCESS-1)*10,DATEADD(DAY,DATEOFACCESS,'1800-12-28T00:00:00.000'))

FROM #SomeClarionValues

DROP TABLE #SomeClarionValues

Cheers!

EDIT: I had mistyped and put a couple identical rows in the...

The date of the last successful CHECKDB is already there. It's the date in the Value column.

Cheers!

There are a few issues with your setup. First, you allow x to be only 1 or 2. According to the problem, x cannot equal 1 (must be >=2), and...

You can open multiple files...

The trancount for those sessions is 2, so it could be as mundane as locks hanging around from other statements in other transactions. In that case, it would appear to...

Just to be clear I understand the requirements, you just want all possible combinations of the sizes and colors in the comma delimited lists, along with a flag that...

Ah, my bad. That was just the fault of my removing the the wrong column from the SELECT list.

I had originally included both columns in the SELECT, and just...

For an alternative syntax, you can also just join on the LIKE (in Bill's code, added while I was typing this you wouldn't need to add the wildcards, since they're...

To be fair, that solution was the very first response to your question 🙂

Yes, you can mirror to a newer version of SQL Server. The caveat there is that once you fail over to the new server, you can't fail the mirror back...

Well, I poked around this problem for a bit, and came up with the following. It has all sorts of warts (I'm not generating my numbers the most efficient way...

Michael L John (9/28/2015)

---

Jacob Wilkins (9/28/2015)

---

The process that Kristen describes will work nicely.

To really minimize downtime, I like to set up mirrors from the old environment to the new. Then...

The process that Kristen describes will work nicely.

To really minimize downtime, I like to set up mirrors from the old environment to the new. Then migration is just failing the...

Kristen-173977 (9/16/2015)

---

Lynn Pettis (9/16/2015)

---

Or this if you want to use a MS provided scalar function:

... but somewhere on my travels I saw this which satisfies my perception that an arithmetic...