Hi Experts,
Here we go. I have below DDL,DML and what I expecting.
select * from langdtl
I need output data as shown below
lang should have to display in alphabetical order separated by comma.
Thanks!
Bhushan
Here we go. I have below DDL,DML and what I expecting.
Code:
create table langdtl(id int,speak_flag int,read_flag int,ia_flag int,lit1_flag int,lit2_flag int,lit3_flag int,lang nvarchar(2))
Code:
insert into langdtl values(1,1,1,1,1,1,0,'fi') insert into langdtl values(1,1,1,0,0,0,1,'sv') insert into langdtl values(1,1,1,1,0,1,0,'en') insert into langdtl values(1,1,1,0,1,1,1,'de')
Code:
insert into langdtl values(2,1,1,0,0,1,1,'fi') insert into langdtl values(2,1,0,1,1,1,0,'sv') insert into langdtl values(2,1,1,0,1,0,1,'en')
I need output data as shown below
Code:
id speak_flag read_flag ia_flag lit1_flag lit2_flag lit3_flag ------------------------------------------------------------------------- 1 de,en,fi,sv de,en,fi,sv en,fi de,fi de,en,fi de,sv 2 de,en,fi,sv en,fi sv en,sv fi,sv en,fi
Thanks!
Bhushan
Comment