Back to OIM Explorer

dbo.DPR_FTSystemMappingRuleEffect

Table FunctionSQL_TABLE_VALUED_FUNCTIONSandbox DB

Table Function.

Source: sandbox-db sys.sql_modules

Source size: 1.389 characters

Interpretation

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

Relations

  • No extracted relations.

Typed Edges

  • No typed edges extracted for this source.

References

  • No direct source references extracted.

Referenced By

  • No direct source references extracted.

Complete Source

SQL65 lines
1CREATE FUNCTION dbo.DPR_FTSystemMappingRuleEffect(2) RETURNS @erg TABLE(UID_DPRSystemMap varchar(38) collate database_default,3UID_DPRSystemMappingRule varchar(38) collate database_default,4Name nvarchar(256) collate database_default5)6  WITH schemabinding7AS8BEGIN9  DECLARE @lauf int10  DECLARE @help dbo.QBM_YParameterList11  INSERT INTO @help(Parameter1,12  Parameter2,13  ContentShort,14  Parameter3)15  SELECT16    m.UID_DPRSystemMap,17    r.UID_DPRSystemMappingRule,18    r.Name,19    m.UID_BaseDPRSystemMap20  FROM dbo.DPRSystemMap m21  JOIN dbo.DPRSystemMappingRule r22    ON m.UID_DPRSystemMap = r.UID_DPRSystemMap23  SELECT @lauf = 124  WHILE @lauf > 025  BEGIN26    INSERT INTO @help(Parameter1,27    Parameter2,28    ContentShort,29    Parameter3)30    SELECT31      DISTINCT e.Parameter1,32      br.UID_DPRSystemMappingRule,33      br.Name,34      e.Parameter335    FROM @help e36    JOIN dbo.DPRSystemMappingRule br37      ON e.Parameter3 = br.UID_DPRSystemMap38    WHERE39      NOT EXISTS(40    SELECT TOP 1 141    FROM @help b42    WHERE43      b.Parameter1 = e.Parameter1 AND b.ContentShort = br.Name)44    SELECT @lauf = @@rowcount45    UPDATE @help46    SET Parameter3 = b.UID_BaseDPRSystemMap47    FROM @help m48    JOIN dbo.DPRSystemMap b49      ON m.Parameter3 = b.UID_DPRSystemMap50    WHERE51      isnull(m.Parameter3,52    '') <> isnull(b.UID_BaseDPRSystemMap,53    '')54    SELECT @lauf += @@rowcount55  END56  INSERT INTO @erg(UID_DPRSystemMap,57  UID_DPRSystemMappingRule,58  Name)59  SELECT60    Parameter1,61    Parameter2,62    ContentShort63  FROM @help64  RETURN65END
Open raw exported source
SQL ยท Raw10 lines
1create function dbo.DPR_FTSystemMappingRuleEffect () returns @erg table (UID_DPRSystemMap varchar(38) collate database_default , UID_DPRSystemMappingRule2 varchar(38) collate database_default , Name nvarchar(256) collate database_default ) with schemabinding as begin declare @lauf int declare @help dbo.QBM_YParameterList3  insert into @help (Parameter1 , Parameter2 , ContentShort , Parameter3 ) select m.UID_DPRSystemMap, r.UID_DPRSystemMappingRule, r.Name, m.UID_BaseDPRSystemMap4 from dbo.DPRSystemMap m join dbo.DPRSystemMappingRule r on m.UID_DPRSystemMap = r.UID_DPRSystemMap select @lauf = 1 while @lauf > 0 begin insert into 5@help (Parameter1 , Parameter2 , ContentShort , Parameter3 ) select distinct e.Parameter1 , br.UID_DPRSystemMappingRule, br.Name, e.Parameter3  from @help6 e join dbo.DPRSystemMappingRule br on e.Parameter3  = br.UID_DPRSystemMap where Not exists (select top 1 1 from @help b where b.Parameter1  = e.Parameter17  and b.ContentShort  = br.Name ) select @lauf = @@rowcount  update @help set Parameter3  = b.UID_BaseDPRSystemMap from @help m join dbo.DPRSystemMap b8 on m.Parameter3  = b.UID_DPRSystemMap where isnull(m.Parameter3 , '') <> isnull(b.UID_BaseDPRSystemMap, '') select @lauf += @@rowcount  end  insert into9 @erg (UID_DPRSystemMap, UID_DPRSystemMappingRule, Name) select Parameter1 , Parameter2 , ContentShort  from @help return end 10