Check out the Case statement in Books Online.

You can write a pretty simple case statement to get this.

Change:

and cast(h.created as datetime) < convert(datetime, floor(convert(float, getdate()))))

to:

and cast(h.created as datetime) < dateadd(hour, 2, convert(datetime, floor(convert(float, getdate())))))

Please post the execution plan for the query. Then we can really help out.

If you aren't sure how to do that:

In management studio, on the toolbar, there's a button...

One of the problems I've seen that causes Excel-as-database solutions is where IT has some byzantine policy for software specification, and it's complex and painful enough that nobody wants to...

Jeff, something I have to ask:

You keep mentioning that recursive CTEs are worse than cursors. I can see that in some cases, but in cases like a hierarchy crawl,...

Glad I could help.

I can understand why char(0) wouldn't work, since it's basically the lack of a character.

I'd have to hear both sides of the story to be sure, but it sure sounds like a good way to go out of business in short order. How...

One thing I find useful, when presenting a case for whatever (expense or anything else), is rehearse it first (if it'll involve any face-to-face, or might).

Play the part of devil's...

You might want to look into something like Satori's BulkMailer (http://www.satorisoftware.com/Products/BulkMailer/default.aspx). It's a pre-packaged solution for CASS and presort, provides all the paperwork, etc. Not very expensive, either,...

Take a look at "Cast and Convert" in Books Online. It has the data on how to get formatted dates out of the system more easily than that.

On an...

Experience counts more than training, in many cases, because so many people get degrees/certs, but don't actually know anything of any value. Not saying that's true in your case,...

You're welcome.

bbaley (1/23/2009)

---

GSquared (1/23/2009)

---

If it doesn't insert because there's no data to insert, or because a trigger rolls back the insert, or some such, then you'll get a 0 for the...

Jeff Moden (1/23/2009)

---

I'm not sure it was worth storing 43 years worth of numbers (480,000,000/30,000/365) even if (at 6 bytes with no overhead) that works out to be just 2.8...

Yes. Right-click on the query pane (in Management Studio), select "Results To", and change it to Text, instead of Grid. That's what I meant by setting the output...