select 错误代码,
(case when 错误代码%2=1 then (select 错误描述 from 表2 where 错误代码=1)+',' else '' end)+
(case when (错误代码/2)%2=1 then (select 错误描述 from 表2 where 错误代码=2)+',' else '' end)+
(case when (错误代码/4)%2=1 then (select 错误描述 from 表2 where 错误代码=3)+',' else '' end)+
........
select 错误代码,
(case when 错误代码%2=1 then (select 错误描述 from 表2 where 错误代码=1)+',' else '' end)+
(case when (错误代码/4)%2=1 then (select 错误描述 from 表2 where 错误代码=2)+',' else '' end)+
(case when (错误代码/8)%2=1 then (select 错误描述 from 表2 where 错误代码=3)+',' else '' end)+
(case when (错误代码/16)%2=1 then (select 错误描述 from 表2 where 错误代码=4)+',' else '' end)+
(case when (错误代码/32)%2=1 then (select 错误描述 from 表2 where 错误代码=5)+',' else '' end)+
(case when (错误代码/64)%2=1 then (select 错误描述 from 表2 where 错误代码=6)+',' else '' end)+
(case when (错误代码/128)%2=1 then (select 错误描述 from 表2 where 错误代码=7)+',' else '' end)+
..................
(case when (错误代码/XXXXXX) %2=1 then (select 错误描述 from 表2 where 错误代码=32) else '' end) as 错误信息
from 表1
select 错误代码,
(case when 错误代码%2=1 then (select 错误描述 from 表2 where 错误代码=1)+',' else '' end)+
(case when 错误代码%4=1 then (select 错误描述 from 表2 where 错误代码=2)+',' else '' end)+
(case when 错误代码%8=1 then (select 错误描述 from 表2 where 错误代码=3)+',' else '' end)+
(case when 错误代码%16=1 then (select 错误描述 from 表2 where 错误代码=4)+',' else '' end)+
(case when 错误代码%32=1 then (select 错误描述 from 表2 where 错误代码=5)+',' else '' end)+
(case when 错误代码%64=1 then (select 错误描述 from 表2 where 错误代码=6)+',' else '' end)+
(case when 错误代码%128=1 then (select 错误描述 from 表2 where 错误代码=7)+',' else '' end)+
..................
(case when 错误代码%XXXXXX=1 then (select 错误描述 from 表2 where 错误代码=32) else '' end) as 错误信息
from 表1