利用自带的master..spt_values将数据按字段切分为多条,例子如下
SELECT top 1000 ry = SUBSTRING (
CONVERT (VARCHAR(999), a.resourceid),
b.number,
charindex(
',',
CONVERT (VARCHAR(999), a.resourceid) + ',',
b.number
) - b.number
) ,*
FROM
workplan a
JOIN master..spt_values b ON b.type = 'p'
AND b.number BETWEEN 1
AND LEN(
CONVERT (VARCHAR(999), a.resourceid)
)
and
SUBSTRING (
',' + CONVERT (VARCHAR(999), a.resourceid),
b.number,
1
) = ','