Hi All
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
cid tid
4088681 0
4088681 0
4088681 15172887
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 :-
aaa
bbb
ccc
ddd
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
For Products
------------
Id Product
81 aaaa
81 aaaa
81 bbbb
I need it to display in the following format
id Product
81 aaaa,aaaa,bbbb
Please get me a solution for these two questions.
