Use this to break a single row of elements into multiple rows.


DECLARE @stuff as nvarchar(1000) = '6,,7,99,3,22,4' -- String to be parsed.
DECLARE @delimter as nvarchar(1) = ','

SELECT a.b.value('.[1]','nvarchar(20)') AS parts
FROM 
(SELECT CAST('<XMLRoot><RowData>' + REPLACE(@stuff,@delimter,'</RowData><RowData>') + '</RowData></XMLRoot>' AS XML) AS x) AS t
CROSS APPLY x.nodes('/XMLRoot/RowData')a(b)
ORDER BY parts