dbo.QBM_FCVJobParameterToList_fa

1create function dbo.QBM_FCVJobParameterToList_fa (@paramin nvarchar(max)) returns table with schemabinding as return( select z.Zeile as SortOrder, z.ParameterName
2, z.ParameterValue, case when z.crypthide like N'%Crypted%' then 1 else 0 end as isCrypted , case when z.crypthide like N'%Hidden%' then 1 else 0 end as
3 isHidden , z.CryptHide , z.LaengenPruefung as LengthCheck from ( select w.Zeile, w.CryptHide, w.ParameterName, w.ParameterValue , (w.lenParameterName 
4^ len(w.ParameterName)) | (w.lenParameterValue ^ len(w.ParameterValue)) | (w.lenCryptHide ^ len(w.CryptHide)) as LaengenPruefung from ( select (y.DieZeile
5 / 6) as Zeile , try_convert(int, left(max( case when y.DieZeile % 6 = 0 then y.Wert end ), 32)  )as lenParameterName , max( case when y.DieZeile % 6 =
6 1 then y.Wert end ) as ParameterName , try_convert(int, left(max( case when y.DieZeile % 6 = 2 then y.Wert end ), 32) ) as lenParameterValue , max( case
7 when y.DieZeile % 6 = 3 then y.Wert end ) as ParameterValue , try_convert(int, left(max( case when y.DieZeile % 6 = 4 then y.Wert end ), 32) ) as lenCryptHide
8 , max( case when y.DieZeile % 6 = 5 then y.Wert end ) as CryptHide from (  select (ROW_NUMBER() over(order by folge ) -1) as DieZeile, x.value as Wert
9 from ( select s.value, 1 as Folge  from string_split( case when len(@paramin) > 2 then (substring(@paramin, 2 , len(@Paramin)-2)) else '' end , '~') as
10 s ) as x ) as y group by (y.DieZeile / 6) ) as w ) as z ) 
11