I have got two questions.I am trying generate a sql which gives me a Begin time and Ending time.The Data is something like this.
id eid datetime action
15172887 102517 11/18/2004 11:34:47 PM Started Call
15172888 102517 11/18/2004 11:35:36 PM Closed Issue
15172889 102517 11/18/2004 11:35:36 PM Closed Call
Begin Time can be re-opened call,started call,opened call
Ending Time can be Closed call
The call can be attended by multiple persons
for ex :-
I want the begin time and end time of ddd for a particualr id.
Please help me out.I need to fix this today.
It Should be displayed something like this
id begin time End Time
1111 11/18/2004 11:34:47 PM 11/18/2004 11:35:36 PM
My Second Question
My second question associated with the first.
i have got columns called product,agent which depends on the id
The data is something like this
I need it to display in the following format
Please get me a solution for these two questions.
Last edited by mys; 11-30-2004 at 05:35 AM.
Click Here to Expand Forum to Full Width