Here is my issue. I have a stored procedure that returns information on
agent signon and signoff times, as well as the duration of seconds worked.
I need to be able to group this into half hour intervals. Can this be done
with another stored procedure?


AgentID Signon_Time Signoff_Time
Duration_Worked
2004 2004-05-20 08:00:00 2004-05-20 09:59:59
7200



AgentID Signon_Time Signoff_Time
Duration_Worked
2004 2004-05-20 08:00:00 2004-05-20 08:29:59
1800
2004 2004-05-20 08:30:00 2004-05-20 08:59:59
1800
2004 2004-05-20 09:00:00 2004-05-20 09:29:59
1800
2004 2004-05-20 09:30:00 2004-05-20 09:59:59
1800