Concatenate row data into a single data in SQL Server
[CODE]DECLARE @NAME VARCHAR(100) =''SELECT @NAME= @NAME + ',' + NAME FROM VENKAT_NAME_TABLESELECT SUBSTRING(@NAME,1,LEN(@NAME))[/CODE]