DECLARE @list VARCHAR(MAX)
SELECT @list = COALESCE(@list+',' , '') + columnname
FROM tablename
SELECT @list
Comma Separated List from Column in SQL
This code snippet show comma delimited list from sql without function.
Loading
This code snippet show comma delimited list from sql without function.
DECLARE @list VARCHAR(MAX)
SELECT @list = COALESCE(@list+',' , '') + columnname
FROM tablename
SELECT @list