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)

  • January 12, 2011 at 10:10 am

    #1272469

    JJ B (1/12/2011)

    I've been using something similar to your query for a while now, but I hadn't known about the option to convert to varchar(max) and get rid of the tokens. The tokens have caused me some amount of pain and despite doing a great deal of research, I have never seen your solution anywhere. The point is: THANKS!

    JJ - You're welcome. (I have to admit that I picked it up from a post here!)

    Wayne
    Microsoft Certified Master: SQL Server 2008
    Author - SQL Server T-SQL Recipes

    If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
    Links:
    For better assistance in answering your questions
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2