How to Concatenate the Multiple Columns value to Single value

Question

2.00/5 (1 vote)

See more:

Hi,

In my database there are seven columns with the value "Y" and "N". I want to take the "Column Heading" Which the values are "Y" and I want to Concatenate it with Comma. Can any one help me to solve this problem. My requirement is like this:

Column Header: TE HE FE RE YE WE DS
Column Values: Y N N Y N Y Y
N N N N Y N N

OutPut Should be Like this:

for First Row: TE,RE,WE,DS
for Second Row: YE

Thanks in Advance

Posted 2-Apr-12 20:06pm

Member 7946563

Add a Solution

Comments

Sergey Alexandrovich Kryukov 3-Apr-12 2:51am

What did you try so far?
--SA

2 solutions

Solution 2

Select TE +','+RE+','+WE+','+DS from your_table
union 
SElect YE from your_table

Posted 3-Apr-12 3:20am

Photon_

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Pablo Aliskevicius · Accepted Answer · 2012-04-02T21:26:00

I would do something like this:

SQL

select case 
       when len([ekeke]) > 0 then (left([ekeke], len(ekeke) - 1)) 
       else [ekeke] 
       end /* case */ as 'ekeke'
from 
(
    select 
        case when [TE]='Y' then 'te,' else '' end + 
        case when [HE]='Y' then 'he,' else '' end + 
        case when [FE]='Y' then 'fe,' else '' end + 
        case when [RE]='Y' then 're,' else '' end + 
        -- ... more lines here ...
        case when [DS]='Y' then 'ds,' else '' end 
        as 'ekeke'
) v

Hope this helps,
Pablo.

How to Concatenate the Multiple Columns value to Single value

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

How to Concatenate the Multiple Columns value to Single value

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us