Back to OIM Explorer

dbo.QBM_FCVListToJobParameter

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

Source size: 1.345 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_FCVStringToBit source text reference
  • references source dbo.QBM_FCVStringToJobParameter source text reference

References

Referenced By

Complete Source

SQL52 lines
1CREATE FUNCTION dbo.QBM_FCVListToJobParameter(2  @ComponentClass nvarchar(1024),3  @TaskName nvarchar(256),4  @Parameters QBM_YParameterList READONLY5) RETURNS nvarchar(max6)7AS8BEGIN9  RETURN(10  SELECT11    '~' + string_agg(convert(nvarchar(max), CONCAT(dbo.QBM_FCVStringToJobParameter(bu.ParameterName),12    dbo.QBM_FCVStringToJobParameter(bu.ParameterValue), dbo.QBM_FCVStringToJobParameter(CASE13    WHEN bu.IsHidden = 1 AND bu.IsCrypted = 1 THEN14    'HIDDEN|CRYPTED'15    WHEN bu.IsHidden = 1 THEN16    'HIDDEN'17    WHEN bu.IsCrypted = 1 THEN18    'CRYPTED'19  ELSE ''20  END))), N '')21  FROM(22  SELECT CASE23  WHEN xp.Name IS NULL THEN24  CASE25    WHEN26  LEFT(p.Parameter1, 1) = '_' THEN27  p.Parameter128    WHEN29  LEFT(p.Parameter1, 4) = 'Val_' THEN30  p.Parameter131  ELSE 'Val_' + p.Parameter132  END33  ELSE p.Parameter134  END AS ParameterName, p.ContentFull AS ParameterValue, dbo.QBM_FCVStringToBit(p.Parameter2) | ISNULL(xp.IsHidden,35  0) AS IsHidden, dbo.QBM_FCVStringToBit(p.Parameter3) | ISNULL(xp.IsCrypted, 0) AS IsCrypted36  FROM @Parameters p37  LEFT38  OUTER39  JOIN(40  SELECT41    p.Name, p.IsHidden, p.IsCrypted42  FROM JobComponent c43  JOIN JobTask t44    ON c.UID_JobComponent = t.UID_JobComponent45  JOIN JobParameter p46    ON t.UID_JobTask = p.UID_JobTask47  WHERE48    c.ComponentClass = @ComponentClass AND t.TaskName = @TaskName) AS xp49    ON p.Parameter1 = xp.Name50  WHERE51    p.Parameter1 > ' ') AS bu)52END
Open raw exported source
SQL ยท Raw10 lines
1  create   function dbo.QBM_FCVListToJobParameter ( @ComponentClass nvarchar(1024) , @TaskName nvarchar(256) , @Parameters QBM_YParameterList readOnly2     ) returns nvarchar(max) as begin return( select '~' + string_agg (convert(nvarchar(max) ,concat( dbo.QBM_FCVStringToJobParameter(bu.ParameterName)3 , dbo.QBM_FCVStringToJobParameter(bu.ParameterValue)  , dbo.QBM_FCVStringToJobParameter( case when bu.IsHidden = 1 and bu.IsCrypted = 1 then 'HIDDEN|CRYPTED'4 when bu.IsHidden = 1 then 'HIDDEN' when bu.IsCrypted = 1 then 'CRYPTED' else '' end ) )  )  , N''  )  from ( select  case when xp.Name IS null then case5  when LEFT(p.Parameter1, 1) = '_' then p.Parameter1  when LEFT(p.Parameter1, 4) = 'Val_' then p.Parameter1 else 'Val_' + p.Parameter1 end else p.Parameter16 end as ParameterName , p.ContentFull as ParameterValue  , dbo.QBM_FCVStringToBit(p.Parameter2) | ISNULL(xp.IsHidden, 0) as IsHidden , dbo.QBM_FCVStringToBit7(p.Parameter3) | ISNULL(xp.IsCrypted, 0) as IsCrypted from @Parameters p left outer join (select p.Name, p.IsHidden, p.IsCrypted from JobComponent c join8 JobTask t on c.UID_JobComponent = t.UID_JobComponent join JobParameter p on t.UID_JobTask = p.UID_JobTask where c.ComponentClass = @ComponentClass and9 t.TaskName = @TaskName ) as xp on p.Parameter1 = xp.Name  where p.Parameter1 > ' ' ) as bu ) end 10