SQL Server How to array a comm separated field -

this question has answer here:

• how split string can access item x? 36 answers
• split comma seprate value table in sql server 3 answers

i'm need separate out table follows:

i've heard may possible using cursor function? can please?

select id, tag mytable