So you need to cast it like this?

round(cast(5 as float) / cast(3 as float),1)

WayneS (7/22/2010)

---

For everyone that thinks that the BOL reference in the QotD is wrong and that there are just 5 types of indexes: I created a connect item at https://connect.microsoft.com/SQLServer/feedback/details/577460/documentation-types-of-indexes...

WayneS (7/22/2010)

---

I would agree that Unique, filtered and included indexes are a sub-type of the clustered (for Unique) or non-clustered index types. However, according to the latest Microsoft documentation, they...

michael.kaufmann (7/22/2010)

---

Wayne,

first of all thank you for compiling a QotD.

However, I do not quite agree with the solution.

'Unique' is just taking the definition of a clusterd or non-clustered index a...

The URL in the explanation didn't say you cannot use a zero -- at least not that I found.

So why can't you use it? If you have IDENTITY INSERTS...

So if you substitute the '-' with something clearly a...

I had to guess because I didn't know the ^= operator but I knew all the others. I was lucky that the other three were specific enough that I...

This one got me. I selected 5,5,5 because I'm used to having padding spaces with the CHAR datatype. That's why I use Varchar instead when the contents of...

I too got it right but for the wrong reason. I knew that using Null is Null will always be true (regardless of the setting of ANSI_NULLS) so that's...

Jack Corbett (5/5/2010)

---

I got it wrong because I didn't read the script. I read the text where it says you created a non-clustered index on LastName and the query...

Same here. Looks like another bad question. The explanation was good but the answer is still wrong.

I...

Steve Jones - Editor (4/16/2010)

---

They talk to your manager. He/she should know something...

fhanlon (4/16/2010)

---

Non monetary rewards often are way more memorable. When I got my MCDBA my employer at the time bought me a jacket with 'Microsoft Certified DBA' embroidered on...

Even if you receive a non-cash reward, don't you still get taxed on the value of the reward?

As an example, the company gives me a cruise to the Bahamas....

RalphWilson (4/16/2010)

---

Like one of the other respondents, I, too, tend to extend the life of my home computers beyond the normal write-off period for companies. On the other hand,...