我会做这样的事情:

I would do something like this:

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.

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