Post reply

Grouping data...

  • August 21, 2013 at 8:38 am

    #281375

    Hello, I´m new in this forum. Maybe someone can help me with my problem:

    My data looks like this:

    STRBEZ STRNR

    10. Oktober-Straße131

    10. Oktober-Straße132

    18. November-Platz1412

    8. Mai-Platz 131

    8. Mai-Platz 132

    Abstimmungsstraße1411

    Abstimmungsstraße1412

    Ackerweg 711

    As a result I want to get this:

    10. Oktober-Straße 131,132

    18. November-Platz 1412

    8. Mai-Platz 131,132

    an so on...

    Is there a "simple" SQL-Statement for this problem? I have resolved such a problem

    by using a function - but maybe there exists an easier way...

    Thanks vor helping

  • August 21, 2013 at 9:01 am

    #1643504

    There's a method that it's described in the following article

    http://www.sqlservercentral.com/articles/comma+separated+list/71700/

    Read it and return to ask anything that you don't understand.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

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

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