Koen Verbeeck (12/14/2016)

---

sknox (12/14/2016)

---

Koen Verbeeck (12/14/2016)

---

sknox (12/14/2016)

---

The question is written as "How can you identify any differences?"

However, 3 of the four answers fit that question as written.

The question should...

Koen Verbeeck (12/14/2016)

---

sknox (12/14/2016)

---

The question is written as "How can you identify any differences?"

However, 3 of the four answers fit that question as written.

The question should have been "How...

The question is written as "How can you identify any differences?"

However, 3 of the four answers fit that question as written.

The question should have been "How can you most...

Mikael Eriksson SE (11/24/2016)

---

Actually none since limitations of the data type but number 2 works for more years then number 1...

Toreador (11/15/2016)

---

The answer is right, but the explanation is wrong, as it says the answer is 0,1,2,NULL,NULL

If that had been one of the options I might have got it wrong...

You can use source in the text of your R script to bring in a file. Cf http://stackoverflow.com/questions/3502925/include-files-r

Stewart "Arturius" Campbell (9/30/2016)

---

Nice, easy question to end the week on, thanks Steve.

Just a point of confusion in the options:

a table variable, a table in the table, or a temp...

Thanks, Steve! While I think it's...

Of course, for user-defined periods which are used often, the best thing to do is to add these calculations into the generation of your calendar table ( http://qa.sqlservercentral.com/articles/calendar/145206/ )...

Was going to post this. For example, one...

TomThomson (9/9/2016)

---

Since we are not permitted by MS SQL Server to write the literal as .7 instead of as 0.7, we are forced to write at least one digit...

Good question, but the explanation is incomplete. Precision is only half of the story, the other being scale.

1.0 can fit in a number with precision of 1, if the scale...

THIS.

I understand why Andy didn't specify SPARSE, as that...

The correct answer is "it depends."

MOST of the time you'll get two rows as explained in the answer.

HOWEVER, each GETDATE() within each SELECT is evaluated separately. When the separate evaluations...

roger.plowman (8/23/2016)

---

sknox (8/23/2016)

---

roger.plowman (8/23/2016)

---

ANSI_WARNINGS are basically concerned with Null values (ignoring the divide by 0 issue which is really a seperate one). I believe the better solution is never allowing...