Just to get you started, I thought I would post these items for using elapsed time in datetime columns.

This is a solution for parsing elapsed time into days, hours, minutes,...

David Swanson (10/31/2008)

---

Disclaimer: I work at Quest as the PM fro LiteSpeed so you probably have a good idea about what I might recommend.;)

That being said, LiteSpeed's Object Level Recovery...

It’s usually better to store elapsed time in a datetime column as an offset from zero time, 1900-01-01 00:00:00.000. It then allows you to use all the datetime functions...

It is true that I didn't credit "A Few Good Men" in my parody; I guess I just assumed that everyone would know it was a parody of such a...

David Reed (10/29/2008)

---

Michael Valentine Jones (10/29/2008)

---

I can't believe he ripped me off. I posted this on SQLTeam 3 and a half years ago; it's the reason for my forum...

You should post you question on a MySQL forum.

Try the MySQL forum at http://www.dbforums.com/

I can't believe he ripped me off. I posted this on SQLTeam 3 and a half years ago; it's the reason for my forum title there, "Yak DBA Kernel...

If you change to a new domain, the logins will keep working only if the SIDs of the user accounts on the new domain remain the same.

I’m sure it there is any change to the DMCA as result of this, it will be tailored specifically to benefit political campaigns only. They wouldn’t want to make...

That is pure speculation, unless you supply test results to back up that statement.

select

[Year] = right(a.Yr,2)+'-'+right(a.Yr+1,2)

from

( --Test Data

select Yr = 1998 union all

select Yr = 1999 union all

select Yr = 2000 union all

select Yr = 2001 union all

select Yr = 2002 union all

select...

This would also do what you want:

select dateadd(dd,datediff(dd,0,COLUMN_A),0)+COLUMN_B

Yes

What it the DBA's objection?

What is the volume of email that you are planning to send?

Is it fairly simple email, or does it have a lot of attachments?

Database Mail seems...

One thing that helps to drive this is the amount of support staff that can be available remotely. I work in a company with a large on-site data center,...