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 |
|
super1985
Starting Member
1 Post |
 Posted - 2009-05-17 : 15:56:36
|
Hi,I have a table named "historic" where i save all requests' status. I want to calculate the difference between two dates : date when the status is "new" and date when the status is "closed". Then, i want to group the requests by duration of treatment. Example :
number of requests duration of treatement 30 < 1 day 10 < 1 hour 20 < 1 weekIs it possible to have this result ?any help or any comment will be highly appreciated. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-05-18 : 03:15:15
|
It's hard to give a suggestion without knowing you table structure, nor sample data.
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
|
|
|
How to calculate number of requests per period