I would like to parse a delimited column in a table that maintains 12
placeholders into a new table with 12 columns

Each row / string looks something like this: 0;0;0;0;0;0;0;0;0;0;0;0

Does a simple solution exist?

[quoted text, click to view]

[quoted text, click to view]

I'd suggest reading Erland Sommarskog's "Arrays and Lists in SQL
Server" essays:

http://www.sommarskog.se/arrays-in-sql.html

If you don't have time to read the whole thing, he provides some code
you can copy and paste so you can get right back to work, and it looks
like it will do just what you need.