insert into b
select
name,
case a when 'Y' then '1' else '' end +
case b when 'Y' then '2' else '' end +
case c when 'Y' then '3' else '' end
from
a
select
name,
case a when 'Y' then '1' else '' end +
case b when 'Y' then '2' else '' end +
case c when 'Y' then '3' else '' end
from
a
select name,col=(case when a='Y' then '1' else '' end)+
(case when b='Y' then '2' else '' end)+
(case when c='Y' then '3' else '' end)
from A