crmitchell (11/19/2012)

---

Hugo Kornelis (11/19/2012)

---

mbova407 (11/19/2012)

---

Thanks for this question. I always hated/never understood this banker's rounding rule. As you can see from this post it is not just in...

mbova407 (11/19/2012)

---

Thanks for this question. I always hated/never understood this banker's rounding rule. As you can see from this post it is not just in Sql

(...)

Like others said...

rmechaber (11/19/2012)

---

But I "like" this because it shows up a terrible disdain in SQL Server for handling basic mathematics under certain circumstances. I don't like the "it's a floating...

I'm not really happy with the question, and the explanation is just wrong.

When I saw the question, I knew it was going to be related to inaccuracy in the floating...

Neil Thomas (11/16/2012)

---

I'm obviously having a dense Friday.

How does the explanation (all about @@error) relate to the question: "What is returned from #tblTrans when you run the below code:"...?

I'm not...

Roland Alexander STL (11/15/2012)

---

No, I don't believe I'm confused. Have a look at the list at http://msdn.microsoft.com/en-us/library/ms143729.aspx where you'll find this entry:

Use of DEFAULT keyword as default value.

Do not...

I...

Dan Graveen (10/31/2012)

---

Of course I had to read up on LEAD before answering this question. MSDN states: "Notice that because there is no lead value available for the last row...

john.arnott (10/30/2012)

---

Raghavendra Mudugal (10/30/2012)

---

Just trying to understand...

(...)

If the OVER (Order By UserID) was used then XRAY will get the 50.00 as he is on the 5 position and EASY in...

ben.norris (10/30/2012)

---

I am sorry to hear that you perceived my reply as...

First: It does. The CREATE TABLE script does not include a NOT NULL constraint, so the columns are all nullable.

Second: That is...

It's great to see a question about new SQL 2012 functionality. And the question itself is quite good - but it could have been better.

I saw two possible improvements beefore...

Good question, but the explanation is wrong. SQL Server always parses each query.

bitbucket-25253 (10/28/2012)

---

From the justification of what the correct answer is:

Therefore a single value in the WHERE... IN clause...

Definitely a good question.

I regularly use PARSENAME to access the elements of a dot-seperated string. And yet, I still always have to check the documentation to recall which part each...

I...