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|MaxConcurrentConnections01-Feb-2015|2602-Feb-2015|2403-Feb-2015|45................. |
|
|
|
|
|
Max Concurrent Calls for a day in a month