declare @geom geometry = 'MULTILINESTRING((1 1, 5 5), (1 3, 3 1), (-5 3, -8 -2))';
select @geom.STGeometryN(n.rownum).ToString() as Linestring
from
(
select top (@geom.STNumGeometries()) row_number() over(order by @@spid) as rownum
from sys.all_objects
) as n;
EDIT:
declare @g geometry = 'LINESTRING(1 1, 2 3, 4 8, -6 3, 5 2, -4 15)';
select
geometry::STLineFromText(concat('LINESTRING(', @g.STPointN(n.rownum).STX, ' ', @g.STPointN(n.rownum).STY, ',', @g.STPointN(n.rownum+1).STX, ' ', @g.STPointN(n.rownum+1).STY, ')'), 0)
from
(
select top (@g.STNumPoints()-1) row_number() over(order by @@spid) as rownum
from sys.all_objects
) as n;
CLICK HERE to find out more related problems solutions.