Calculating Delays with sql - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Old Forums

CLOSED - General SQL Server

Calculating Delays with sql

Author

Topic

Swati Jain
Posting Yak Master

139 Posts

Posted - 2006-07-11 : 05:42:51

I have three columns in my table,'StartDate',EndDate','BatchID'

When I upadate the the table for 'EndDate' I want to calculate the

I want to store this modified value somewhere and calculate the difference in (Value of 'End Date' Before update)-(Value of 'EndDate' after Update')

How it is possible?
Thanks in advance
Swati

Kristen
Test

22859 Posts

Posted - 2006-07-11 : 07:16:39

~~Duplicate of http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=68888~~

I now find that folk have answered on yet another copy of this post:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=68886

It is extremely annoying for people here to answer in one thread and find that there are already answers elsewhere. Please do not cross-post

Kristen

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources