Back to OIM Explorer

dbo.DPR_FTJournalPropertySplit

Inline Table FunctionSQL_INLINE_TABLE_VALUED_FUNCTIONSandbox DB

Inline Table Function.

Source: sandbox-db sys.sql_modules

Source size: 560 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_FCVStringToList source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL21 lines
1CREATE FUNCTION dbo.DPR_FTJournalPropertySplit(2  @UID_DPRJournalProperty varchar(38)3) RETURNS TABLE4AS5RETURN(6SELECT7  p.UID_DPRJournalProperty,8  p.PropertyName,9  e.ParameterValue AS NewValueElement,10CASE p.IsOldValueFull11  WHEN 1 THEN12p.OldValueFull13ELSE p.OldValueShort14END AS OldValue15FROM DPRJournalProperty p CROSS apply dbo.QBM_FCVStringToList(CASE p.IsNewValueFull16WHEN 1 THEN17p.NewValueFull18ELSE p.NewValueShort19END, nchar(13) + nchar(10), 1, 0) AS e20WHERE21  p.UID_DPRJournalProperty = @UID_DPRJournalProperty AND p.PropertyName LIKE '%member%')
Open raw exported source
SQL ยท Raw5 lines
1create function dbo.DPR_FTJournalPropertySplit (@UID_DPRJournalProperty varchar(38) ) returns table as return( select p.UID_DPRJournalProperty ,p.PropertyName2 ,e.ParameterValue AS NewValueElement , case p.IsOldValueFull when 1 then p.OldValueFull else p.OldValueShort end as OldValue from DPRJournalProperty p3 cross apply dbo.QBM_FCVStringToList ( case p.IsNewValueFull when 1 then p.NewValueFull else p.NewValueShort end , nchar(13) + nchar(10), 1, 0) as e where4 p.UID_DPRJournalProperty = @UID_DPRJournalProperty and p.PropertyName like '%member%' ) 5