Hi All,
I have an issue while doing the caclulation to find out the concurrent user (per Application, per vendor and Per Applion &Vendor )
| Application | Vendor | Start Time | End Time | User ID |
| A | X | 1-1-2011 10:50 | 1-1-2011 14:07 | 11111 |
| A | Y | 1-1-2011 11:07 | 1-1-2011 16:07 | 22222 |
| A | X | 3-1-2011 10:50 | 3-1-2011 18:50 | 33333 |
| B | Y | 1-1-2011 11:19 | 1-1-2011 15:17 | 44444 |
| B | X | 2-1-2011 10:50 | 3-1-2011 11:50 | 11111 |
| B | X | 1-1-2011 10:55 | 1-1-2011 15:17 | 55555 |
For Example I have the Above data and I need to find out the max Concurrent (at certain point of time ie. vary with timing ) user for Application A , For Vendor X and for Application A & Vendor X (combindely).
Your help will be highly appriciated.
Thanks!
D J
