Comma separated list of values of single Database table field

Here is a line of T-SQL solution to get comma separated list of values of single field of a database table
 

DECLARE @commaSeparatedVal AS VARCHAR(4000)

SELECT @commaSeparatedVal = ISNULL(@commaSeparatedVal +',','') + CONVERT(VARCHAR,[SKU]) FROM PRODUCT

PRINT @commaSeparatedVal

 

Comments

# Comma separated list of values of single Database table field - SQL Server « KaushaL.NET

Pingback from  Comma separated list of values of single Database table field - SQL Server « KaushaL.NET

# list of values

Friday, July 11, 2008 12:51 AM by list of values

Pingback from  list of values