Post reply

SQL Group and merge...

  • October 11, 2011 at 2:01 pm

    #245185

    Hello SQL Experts,

    I have a question... I want to group and then merge one column that has different values in one. Example -->

    nametelefoncity

    max456berlin

    max345berlin

    nick 123 new york

    and I want them that way -->

    max 456,345 berlin

    nick 123 new york

    So I want them group by name and city but the telefon columns should be merged in one...

    Is there a good way to solve this problem? Maybe using rownumber???

    Thank you!!!:-):-)

  • October 12, 2011 at 2:47 am

    This was removed by the editor as SPAM

  • October 12, 2011 at 3:03 am

    #1393302

    Wow!!! Thats exactly what I am looking for!!!! A really smart solution!!! Thanks a lot Stewart "Arturius" Campbell!!!! I will study this article carrefully!!! Thanks again!!!! :-):-):-)

    Kind Regards

    rena

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

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