Post reply

Merge rows, how?

  • October 25, 2005 at 12:05 pm

    #90685

    If I have a table that goes like this:

    fieldid     userid      eventid     response

    111        100         200            AAA

    111         100        200            BBB

    112        100         200            response112

    ...         ...            ...               ....

    And I have some rows that have everything identical but Column Response.

    How can I have create #temp table from it so that all the rows that have the same fieldid for example would merge together and their Response field would become "AAA, BBB" (from example above)

    I hope someone can help.

  • October 25, 2005 at 12:10 pm

    #599902

    Permanent change or presentation only?

  • October 25, 2005 at 3:37 pm

    #599968

    How many topics about this matter we must have?

    _____________
    Code for TallyGenerator

  • October 25, 2005 at 9:43 pm

    #600001

    I stopped counting the recuring questions... I just saved the answers and paste them back .

Viewing 4 posts - 1 through 3 (of 3 total)

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