"Kent Prokopy" <KentProkopy@discussions.microsoft.com> wrote in message
news:C8F66421-2221-42AB-9F21-ECE73F625008@microsoft.com...
> I have a table that stores three fields of information.
> (AgentID Int, Orig DateTime, Term DateTime)
>
> Example:
> AgentID = 1, Orig = '12/27/2004 9:00:00 AM', Term = 4:59:59 PM
>
> I would like a t-sql that will display this data in half hour intervals
for
> me.
>
> Example:
> AgentID = 1, Orig_Interval = '12/27/2004 9:00:00 AM', Duration = 1800
> AgentID = 1, Orig_Interval = '12/27/2004 9:30:00 AM', Duration = 1800
> ""
> ""
> Last record would be like:
> AgentID = 1, Orig_Interval = '12/27/2004 4:59:59', Duration = 1799
>