Hi,
I have a table like below
create table #table1 (EmpName varchar(50), Section nvarchar(200));
create table #Result (EmpName varchar(50), Section1 nvarchar(200), Section2 nvarchar(200), Section3 nvarchar(200));
insert into #table1 values ('AAA', '1111')
insert into #table1 values ('AAA', '2222')
insert into #table1 values ('AAA', '3333')
insert into #table1 values ('BBB', '1111')
insert into #table1 values ('BBB', '2222')
insert into #table1 values ('CCC', '3333')
insert into #Result values ('AAA', '1111', '2222', '3333')
insert into #Result values ('BBB', '1111', '2222', '')
select from #table1;
select from #Result
drop table #table1;
drop table #Result;
i need the result as Result table. the column count change dynamically.
Thanks
