create function dbo.NormalizeSizes (@values SizedUnits)
returns table as
return
with split as (
select
v.SourceRowId
,[1] = substring(v.Units,1,4)
,[2] = substring(v.Units,5,4)
,[3] = substring(v.Units,9,4)
,[4] = substring(v.Units,13,4)
,[5] = substring(v.Units,17,4)
,[6] = substring(v.Units,21,4)
,[7] = substring(v.Units,25,4)
,[8] = substring(v.Units,29,4)
,[9] = substring(v.Units,33,4)
,[10]= substring(v.Units,37,4)
,[11]= substring(v.Units,41,4)
,[12]= substring(v.Units,45,4)