Home Forums Article Discussions Article Discussions by Author Discuss content posted by Wayne Sheffield Creating a comma-separated list (SQL Spackle) RE: Creating a comma-separated list (SQL Spackle)

  • May 5, 2013 at 9:44 am

    #1612466

    opc.three (5/4/2013)

    ...when this is so easily done without it and it works in a stored procedure or a function without having to somehow get to the command line to do it?

    How would you do it in T-SQL?

    If you're just outputing a result set (which is the object of the article... not exporting data), then just like the article does with the [text] kicker. I'm not sure why anyone would even bring up PowerShell in such a situation.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)