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.
| Author |
Topic |
|
koolmission
Starting Member
4 Posts |
 Posted - 2008-02-27 : 06:52:31
|
| i have got two date variable startdate and enddate and there one table called eventin event table there is |eventid| eventname|eventstatus|eventtimei have to check event time and find the time difference between the vents first i have to took startdate as first values then find datadiffernce with the first event time checking the event is billable or notif the value is billable then fetch next event time and find the date difference the last difference with the end time how it can done in stroed procedure please help guys |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-02-27 : 07:27:18
|
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
|
|
|
Sql Server