select FTYKH, 'ksdm'=substring(a.FCAL,b.number,charindex(',',a.FCAL+',',b.number)-b.number) ,FKSNAME
from DIM_TWORKROOM a
inner join master.dbo.spt_values b on b.number between 1 and len(a.FCAL)
and substring(','+a.FCAL,b.number,1)=','
where b.type='P'
sqlserver,拆分分隔符并转换为列表格
最新推荐文章于 2024-03-22 09:31:34 发布