Post reply

Is there a SQL funtion to concatenate a column from several rows into 1 string?

  • October 23, 2013 at 5:41 am

    #279059

    Is there a SQL funtion to concatenate a column from several rows into 1 string? Do I need to build my own?

    <><
    Livin' down on the cube farm. Left, left, then a right.

  • October 23, 2013 at 5:50 am

    #1660868

    Not a pre-defined function, but there are several methods to achieve your requirement.

    Concatenating Row Values in Transact-SQL[/url]

    The XML one is my favorite.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • October 23, 2013 at 6:06 am

    #1660871

    Thanks. There are some interesting options.

    <><
    Livin' down on the cube farm. Left, left, then a right.

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

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