How to split XML array into separate rows (while upholding consistency)
Does something like this satisfy the resultset?

Table &amp; Data

CREATE TABLE #TestingIdea (
Id int PRIMARY KEY IDENTITY (1,1),
PostId int NULL,
Tag nvarchar (MAX) NULL
)

INSERT INTO #TestingIdea(PostId,Tag)
VALUES(1,'&lt;mysql&gt;&lt;innodb&gt;&lt;myisam&gt;')

GO


Query

SELECT PostId, RIGHT(value,len(value)-1) as SplitTag
FROM #TestingIdea 
CROSS APPLY string_split(tag,'&gt;')
WHERE value != ''


Result

PostId  SplitTag
1   mysql
1   innodb
1   myisam