hi, I need to convert rows into comma separated values example, i want to convert : Name ------------------------------ India USA Japan China Switzerland to Name ------------------------------------ India, USA, Japan, China, Switzerland
hi Murari, Thanks, your code is working, but i have modified your code as below for better output: Declare @var varchar(max) set @var = select @var = @var+ + columnname from tablename select @var as columnname Rakesh
Declare @var varchar(max) set @var = select @var = @var + name from tablename select @var as name