J
Jeff Shantz
Hello all,
This may not be the appropriate forum, but I'm going to try my luck.
I'm designing an ASP.NET application in C# for my company. The
application grabs call center statistics for CSR's on a nightly basis,
and imports that data into its own database. Thus, the application is
used mainly for trending/reporting.
The agents are assigned to supervisors. One design aspect that I'm
struggling with is that agents can be reassigned to different
supervisors at any time. But if agent X gets reassigned to Supervisor
B, we still want Agent X's old statistics to appear in team reports
for Supervisor A, when those reports are generated during the time
period where Agent X was still under Sup A.
I've been running through various scenarios in my head, but I can't
seem to find an attractive method. Is this possible to doing on the
query-level using SQL, or am I going to have to grab the data into a
dataset and manipulate it at the application level, checking each
record to see if the agent belonged to that supervisor at that
particular period in time?
I hope I've explained this properly. Any suggestions would be
appreciated.
This may not be the appropriate forum, but I'm going to try my luck.
I'm designing an ASP.NET application in C# for my company. The
application grabs call center statistics for CSR's on a nightly basis,
and imports that data into its own database. Thus, the application is
used mainly for trending/reporting.
The agents are assigned to supervisors. One design aspect that I'm
struggling with is that agents can be reassigned to different
supervisors at any time. But if agent X gets reassigned to Supervisor
B, we still want Agent X's old statistics to appear in team reports
for Supervisor A, when those reports are generated during the time
period where Agent X was still under Sup A.
I've been running through various scenarios in my head, but I can't
seem to find an attractive method. Is this possible to doing on the
query-level using SQL, or am I going to have to grab the data into a
dataset and manipulate it at the application level, checking each
record to see if the agent belonged to that supervisor at that
particular period in time?
I hope I've explained this properly. Any suggestions would be
appreciated.