Back to OIM Explorer

dbo.QBM_FCVJobParameterToList_fa

Inline Table FunctionSQL_INLINE_TABLE_VALUED_FUNCTIONSandbox DB

Inline Table Function.

Source: sandbox-db sys.sql_modules

Source size: 1.464 characters

Interpretation

  • Database function. Usually supports views, validation, or calculated predicates; look at referenced-by entries for callers.

Relations

  • No extracted relations.

Typed Edges

  • references source dbo.QBM_FCVJobParameterToList source text reference

References

Referenced By

Complete Source

SQL62 lines
1CREATE FUNCTION dbo.QBM_FCVJobParameterToList_fa(2  @paramin nvarchar(max)3) RETURNS TABLE4  WITH schemabinding5AS6RETURN(7SELECT8  z.Zeile AS SortOrder,9  z.ParameterName,10  z.ParameterValue,11CASE12  WHEN z.crypthide LIKE N '%Crypted%' THEN13114ELSE 015END AS isCrypted,16CASE17  WHEN z.crypthide LIKE N '%Hidden%' THEN18119ELSE 020END AS isHidden,21z.CryptHide,22z.LaengenPruefung AS LengthCheck23FROM(24SELECT25  w.Zeile, w.CryptHide, w.ParameterName, w.ParameterValue,(w.lenParameterName ^ len(w.ParameterName)) |(w.lenParameterValue ^ len(w.ParameterValue26  )) |(w.lenCryptHide ^ len(w.CryptHide)) AS LaengenPruefung27FROM(28SELECT29  (y.DieZeile / 6) AS Zeile, try_convert(int,30  LEFT(max(CASE31  WHEN y.DieZeile % 6 = 0 THEN32  y.Wert33END), 32)) AS lenParameterName, max(CASE34WHEN y.DieZeile % 6 = 1 THEN35y.Wert36END) AS ParameterName, try_convert(int,37LEFT(max(CASE38WHEN y.DieZeile % 6 = 2 THEN39y.Wert40END), 32)) AS lenParameterValue, max(CASE41WHEN y.DieZeile % 6 = 3 THEN42y.Wert43END) AS ParameterValue, try_convert(int,44LEFT(max(CASE45WHEN y.DieZeile % 6 = 4 THEN46y.Wert47END), 32)) AS lenCryptHide, max(CASE48WHEN y.DieZeile % 6 = 5 THEN49y.Wert50END) AS CryptHide51FROM(52SELECT(ROW_NUMBER() over(53ORDER BY folge) -1) AS DieZeile, x.value AS Wert54FROM(55SELECT56  s.value, 1 AS Folge57FROM string_split(CASE58WHEN len(@paramin) > 2 THEN59(substring(@paramin, 2, len(@Paramin) -2))60ELSE ''61END, '~') AS s) AS x) AS y62GROUP BY(y.DieZeile / 6)) AS w) AS z)
Open raw exported source
SQL ยท Raw11 lines
1create function dbo.QBM_FCVJobParameterToList_fa (@paramin nvarchar(max)) returns table with schemabinding as return( select z.Zeile as SortOrder, z.ParameterName2, 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 as3 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.DieZeile5 / 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( case7 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 lenCryptHide8 , 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 Wert9 from ( select s.value, 1 as Folge  from string_split( case when len(@paramin) > 2 then (substring(@paramin, 2 , len(@Paramin)-2)) else '' end , '~') as10 s ) as x ) as y group by (y.DieZeile / 6) ) as w ) as z ) 11