Back to OIM Explorer

dbo.CPL_FTCCSOrgCheckWithPWO_

Table FunctionSQL_TABLE_VALUED_FUNCTIONSandbox DB

Table Function.

Source: sandbox-db sys.sql_modules

Source size: 557 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.CPL_FTCCSOrgCheckWithPWO source text reference
  • references source dbo.QBM_FCVStringToList source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL22 lines
1CREATE FUNCTION dbo.CPL_FTCCSOrgCheckWithPWO_(2  @ObjecKeysOfPWO nvarchar(max)3) RETURNS @erg TABLE(UID_Org varchar(38) collate database_default,4UID_ComplianceRule varchar(38) collate database_default5)6AS7BEGIN8  DECLARE @ObjecKeysOfPWO_L QBM_YParameterList9  INSERT INTO @ObjecKeysOfPWO_L(Parameter1)10  SELECT y.ParameterValue11  FROM dbo.QBM_FCVStringToList(@ObjecKeysOfPWO,12  '|',13  1,14  0) AS y15  INSERT INTO @erg(UID_Org,16  UID_ComplianceRule)17  SELECT18    a.UID_Org,19    a.UID_ComplianceRule20  FROM dbo.CPL_FTCCSOrgCheckWithPWO(@ObjecKeysOfPWO_L) a endLabel:21  RETURN22END
Open raw exported source
SQL ยท Raw5 lines
1create function dbo.CPL_FTCCSOrgCheckWithPWO_ (@ObjecKeysOfPWO nvarchar(max) ) returns @erg table (UID_Org varchar(38) collate database_default , UID_ComplianceRule2 varchar(38) collate database_default ) as begin declare @ObjecKeysOfPWO_L QBM_YParameterList insert into @ObjecKeysOfPWO_L(Parameter1) select y.ParameterValue3 from dbo.QBM_FCVStringToList( @ObjecKeysOfPWO, '|' , 1, 0) as y insert into @erg(UID_Org, UID_ComplianceRule) select a.UID_Org, a.UID_ComplianceRule from4 dbo.CPL_FTCCSOrgCheckWithPWO(@ObjecKeysOfPWO_L) a endLabel: return end 5