Multilinestring to Linestrings

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.

Leave a Comment

Your email address will not be published.

Scroll to Top