Results 1 to 2 of 2

Thread: commas in col

  1. #1
    Join Date
    Mar 2004
    Posts
    2

    Arrow Unanswered: commas in col

    How do I display comma separated values in a column using column A of tbl MMM

    Say Col B of tbl NNN = Col C of Tbl MMM

    I'm displaying values in tbl NNN & col A from MMM.
    I have rows like
    xxx yyy 1 zzz
    xxx yyy 2 zzz
    xxx yyy 3 zzz
    but I want
    xxx yyy 1,2,3 zzz


    What's the SQL (MS SQL Server)?

  2. #2
    Join Date
    Mar 2004
    Posts
    2

    Lightbulb Re: commas in col

    What's the MS SQL Server SQL for making rows

    xxx yyy 1 zzz
    xxx yyy 2 zzz
    xxx yyy 3 zzz

    into a row
    xxx yyy 1,2,3 zzz

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •