Home Forums SQL Server 2012 SQL Server 2012 - T-SQL SQL Distinct comma delimited list RE: SQL Distinct comma delimited list

  • July 24, 2013 at 7:41 am

    #1635353

    Easiest way

    DECLARE @listStr VARCHAR(MAX)

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

    FROM Production.Product

    GROUP BY Name

    SELECT @listStr

    🙂