lhowe (4/7/2010)

---

Another method to strip the time from a date/time value and keep it as a datetime type would be: CONVERT(datetime,CONVERT(varchar,GetDate(),101))

I'm sure none of you would store dates as characters, but it does happen.

CirquedeSQLeil (4/9/2010)

---

It is my understanding from the SSAS and SSIS that SFTPLA is diligently searching for a TSLOTALA for POTUS to replace the FLOTALA.

CirquedeSQLeil (4/8/2010)

---

Here's one for y'all.

lmu92 (4/9/2010)

---

CirquedeSQLeil (4/9/2010)

---

...

And the State Security Annihilation Service doesn't bother asking questions - they just act.

That's where the QA (question asking tool) comes into play...

BrainDonor (4/9/2010)

---

Why do so few people understand the basic principles behind backups?

CirquedeSQLeil (4/8/2010)

---

Enema?

Tom.Thomson (4/9/2010)

---

I have to disagree. What you are telling me is that the length of the check expression is 5. That is pure nonsense.

The Dixie Flatline (4/8/2010)

---

Well, I don't know how you people in Las Vegas like to talk..... 😉

Paul White NZ (4/8/2010)

---

I see nothing wrong with the original explanation. It correctly conveys the reason that the result is 'IsUnk' and not 'IsUnknown'.

In SQL Server 2005 the IsNull() function will truncate the length of replacement_value to that of check_expression.

Hugo Kornelis (4/8/2010)

---

CirquedeSQLeil (4/8/2010)Is 0/0 = 1 or is 0/0 an error?

To that question, my answer is a clear and resounding "yes"! 😛