Proper way to concatenate values in a set from 1 column

  • Thanks. Not sure if you are aware but you'll want to watch out for entitization when using the XML method.

    Search for 'entitized' on this page for some details and tested code from Adam Machanic:

    http://www.simple-talk.com/sql/t-sql-programming/concatenating-row-values-in-transact-sql/[/url]

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • opc.three (2/1/2013)


    Thanks. Not sure if you are aware but you'll want to watch out for entitization when using the XML method.

    Search for 'entitized' on this page for some details and tested code from Adam Machanic:

    http://www.simple-talk.com/sql/t-sql-programming/concatenating-row-values-in-transact-sql/[/url]

    Sweet! Thanks!

    Jared
    CE - Microsoft

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

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