create table #1(something varchar(100))
insert into #1(something)
values('314,24;234,12')

declare @xml xml
select @xml = convert(xml,'<root><x><b>' + replace(REPLACE([something], ';', '</v></x><x><b>'),',','</b><v>') + '</v></x></root>') from #1

select id = o.value('b[1]', 'varchar(100)'),
              name = o.value('v[1]', 'varchar(100)')
from (select x = @xml)a
       cross apply x.nodes('/root') x(v)
       cross apply v.nodes('x') y(o)