String extract, Sql Server

Language: Layout:

--Sql Server 2014 Express Edition
--Batches are separated by 'go'

with t as (
      select 1 as id, 'a|b' as product, '1|2' as quantity union all
      select 2, 'a|b|c' as product, '1|2|4' as quantity union all
      select 3, 'a' as product, '18' as quantity
     ),
     cte as (
      select id,
             left(product, charindex('|', product + '|') - 1) as product,
             left(quantity, charindex('|', quantity + '|') - 1) as quantity,
             substring(product, charindex('|', product + '|') + 1, 1000) as products,
             substring(quantity, charindex('|', quantity + '|') + 1, 1000) as quantities
     from t
     union all
      select id,
             left(products, charindex('|', products + '|') - 1) as product,
             left(quantities, charindex('|', quantities + '|') - 1) as quantity,
             substring(products, charindex('|', products + '|') + 1, 1000) as products,
             substring(quantities, charindex('|', quantities + '|') + 1, 1000) as quantities
     from cte
     where products <> '' and quantities <> ''
    )
select id, product, quantity, products, quantities
from cte

View schema
Execution time: 0,03 sec, rows selected: 6, rows affected: 0, absolute service time: 0,17 sec