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 |
|
vijay1234
Starting Member
48 Posts |
 Posted - 2015-02-27 : 04:16:45
|
Hi,
I have a table with StartTime,EndTime,PhoneNumberOrig,PhoneNumberDest,NoofMinutes as columns.
Data is available in the following way.
2015-02-27 14:59:57.000|2015-02-27 16:13:38.000|333-333-3333|444-444-4444|78|
2015-02-27 14:59:57.000|2015-02-27 15:13:38.000|333-333-3333|444-444-2222|14|
...............
There will be many calls in a day. So there could be some parallel phone calls for any period from any number to any number.
Need a query to get that maximum parallel connections or the maximum concurrent connections which happened for a day as per the above available data.
Can ingore seconds & milli seconds. Only the Hrs & Mins part should be considered.
Result :
Day|MaxConcurrentConnections
01-Feb-2015|26
02-Feb-2015|24
03-Feb-2015|45
........
.........
|
|
|
|
|
|
Max Concurrent Calls for a day in a month