report logic might have a slight flaw. I get why you'd do this for ER visits over midnight, but what if the patient comes in on Friday at noon, goes...

David Cuthill (10/1/2012)

---

@jscrawf2 Please do not use quotemarks if you are not quoting verbatim.

In answer to your question: yes. Are you asking for help? If so,...

David Cuthill (10/1/2012)

---

Articles such as this really do need to be written with perfect punctuation. If not, credibility is zeroed.

The author is made to appear ignorant of their own...

Kiara (9/28/2012)

---

I'd be at the Chicago event, except...

I wasn't saying it can't be done, I was saying you're doing it incorrectly.

IIf() works off of three values, Test, True and False. You're feeding in a fourth value,...

Kinda rough suggestion, I realize it, but basically Why Bother?

Install SSMS Tools Pack (free) or buy RedGate SQL Prompt.

Works lots better than Intellinonsense.

Change all objects into a new schema, then see who complains and transfer those back...

(clarification: that's a joke)

Ignore Jeff, he has a beard. I, on the other hand, actually OWN a Gillette. I would imagine taking part in Open Source also keeps Microsoft's ear to the ground...

Not sure exactly what you're evaluating, but looks to me like you have four arguments in the IIf() function, when it only accepts three.

procrastineering[/url]

SQLBalls (9/20/2012)

---

(my XML is rusty and I need to brush up, so excuse the lack of detail in the reply).

At this level it appears that way, but when you get...

John/Bob, while not an expert, I would have to say no, they are not...

Eugene Elutin (9/19/2012)

---

I've spent 5 minutes to choose...

Morose (I've just been informed that not only was it Talk Like A Pirate Day yesterday, but if you dressed like a pirate, you...

L' Eomot Inversé (9/18/2012)

---

No, it doesn't. ...