Home Forums SQL Server 2005 T-SQL (SS2K5) CONVERT COLUMN VALUES TO COMMA SEPARATED ONE ROW VALUE.. RE: CONVERT COLUMN VALUES TO COMMA SEPARATED ONE ROW VALUE..

  • October 8, 2012 at 9:40 am

    #1546802

    USE AdventureWorks

    GO

    DECLARE @listStr VARCHAR(MAX)

    SELECT @listStr = COALESCE(@listStr+',' ,'') + Name

    FROM Production.Product

    SELECT @listStr