SQLServer 将单元格内以“，”分隔的数据转成行

 SQLServer 将单元格内以“，”分隔的数据转成行

select value from(
select[values] = CONVERT(xml,'<root><v>' + REPLACE([values], ',', '</v><v>') + '</v></root>') from 表 where keys='SelectedPeriod'
)A
outer apply(
SELECT value = N.v.value('.', 'varchar(100)') FROM A.[values].nodes('/root/v') N(v)
)B