Jean-François Bergeron (11/5/2008)

---

A trigger is good for the update statement, but I propose you use a simple default value for the new value. Here's how:

USE tempdb

GO

CREATE TABLE [dbo].[Test]

...

The "Anything that is NOT about SQL!" forum?

You could also say that is the "Quantum mechanics" or "Medieval History" forum,...

Yes, and then you get into all sorts of issues with rounding, overflow, etc. if you use integers.

declare @t table (ST datetime, ET datetime)

print 'Load Test Data'

insert into @t

select

*

from

( --Test...

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