Post reply

Creating Comma seperated list of details from multiple columns

  • June 5, 2010 at 2:15 am

    #1176782

    Thank you for proving my argument [Smile]

    Eh? The argument seems to be that if you restrict the number of emails in the list to 5, then the problem is trivial. What happens when someone in the list has more than five? How do you use the PIVOT if the list can be any number? Doyle_31 doesn't say that he only wants the first five emails in the list.

    Best wishes,
    Phil Factor

  • September 18, 2014 at 10:11 am

    #1746473

    Hi

    I Have a very critical issue in Comma separated values using XML Path

    I have table "MENU" storing data as mentioned below

    MENU Table:

    -----------------

    CallStartDateTime MenuNames

    2014-09-18 srinivas;saipu;vasu;krishna;srinivas;saipu;krishna

    2014-09-17 srinivas;saipu;vasu;krishna;srinivas;saipu;krishna;vasu;saipu

    2014-09-18 krishna;srinivas;saipu;vasu

    2014-09-18 saipu;vasu;a1;a2;a3;.......a100

    2014-09-16 saipu;vasu;a1;a2;a3;.......a100

    2014-09-18 a100;a99;a34;saipu;vasu;krishna;

    Output required:Table Name as "TEMP"

    TEMP TABLE:

    ---------------

    CallStartDateTime MenuNames

    2014-09-18 srinivas;saipu;vasu;krishna;srinivas;saipu;krishna; krishna;srinivas;saipu;

    vasu;saipu;vasu;a1;a2;a3;.......a100; a100;a99;a34;saipu;vasu;krishna;

    Everytime I need to get getdate-1 records to temp table.

    Please help me.

    Thanks

    Srini

Viewing 2 posts - 16 through 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply