DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Sql

Threaded View

  1. #1
    Join Date
    Dec 2002
    Posts
    40

    Sql

    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.
    Last edited by mys; 11-30-2004 at 05:35 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width