5.5.09

Row data as a comma seperated string

Problem statment:
Am having lot of records in my table. I need to take the rows and converted in to a comma seperated string. Is it possible?

create table venkatTable(subject varchar(10),marks int,Gender varchar(10))
insert into venkatTable values('Maths',50,'F')
insert into venkatTable values('Maths',20,'M')
insert into venkatTable values('English',50,'F')
insert into venkatTable values('English',30,'M')
insert into venkatTable values('Physics',50,'F')
insert into venkatTable values('Physics',70,'M')

declare @val varchar(100)
set @val=''
select @val=@val+','+subject from venkatTable
print substring(@val,2,len(@val))


Thanks and Regards,
Venkatesan Prabu .J

1 comment:

  1. Amazing Venkat, I got confused a lot using recursive CTE, this solution is elegant!
    thanks

    ReplyDelete