SQL Group and merge...

• rena24

  Default port

  Points: 1482

  More actions

  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

• rena24

  Default port

  Points: 1482

  More actions

  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