Show column data in a comma separated single line.

Hi All,

        Thanks for your valuable answers.

Anurag Singh

Hi..

You can make a function and use LISTAGG.

Call this function in your select query.

DECLARE @commavalue VARCHAR(Max);

SELECT @commavalue = COALESCE(@commavalue + ', ', '') + CAST(Name AS varchar(20)) FROM topic C
SELECT @commavalue

try this

 

Select  ',' +Name from <tableName> for XML Path(''), Type

Hi Anurag,
you can accomplish your requirement by creating one Stored Procedure.
see below for SP

CREATE PROCEDURE GetSepratedValue
(
 @TableName Varchar(100), @ColumnName Varchar(100), @Delimeter Char(1)
)
AS
BEGIN
 DECLARE @TEMP TABLE (ID INT IDENTITY,MYCOLUMN VARCHAR(200) )
 DECLARE @TotRows INT
 DECLARE @Result Varchar(MAX)=''
 INSERT INTO @TEMP (MYCOLUMN)
 EXEC  (N'SELECT ' + @ColumnName + ' FROM ' + @TableName)
 SET @TotRows = @@ROWCOUNT
 DECLARE @MIN INT = 1
 WHILE(@MIN < @TotRows)
 BEGIN
 SELECT @RESULT = @RESULT + MYCOLUMN + ',' FROM @TEMP WHERE ID = @MIN
 SET @MIN +=1
 END
 SELECT SUBSTRING(@Result,1,LEN(@RESULT)-1)
END
--  EXEC GetSepratedValue  'TestTable', 'TestColumn', ','

Thanks.

I Hope its working as per your requirement.
select STUFF((select '',''+rtrim(t.Name)from table Name t
  for XML Path('''')),1,1,'''') Name,