dbo.DPR_FTSystemMappingRuleEffect

SQL_TABLE_VALUED_FUNCTION

Created 2026-04-14T23:16:47.157 · modified 2026-04-14T23:16:47.157 · source: live DB sys.objects/sys.sql_expression_dependencies.

Open formatted source/search result

Parameters

Name	Type	Output
No parameters.

Referenced objects

Schema	Object	Column/minor	Class
dbo	DPRSystemMap		OBJECT_OR_COLUMN
dbo	DPRSystemMap	UID_DPRSystemMap	OBJECT_OR_COLUMN
dbo	DPRSystemMap	UID_BaseDPRSystemMap	OBJECT_OR_COLUMN
dbo	DPRSystemMappingRule		OBJECT_OR_COLUMN
dbo	DPRSystemMappingRule	UID_DPRSystemMappingRule	OBJECT_OR_COLUMN
dbo	DPRSystemMappingRule	UID_DPRSystemMap	OBJECT_OR_COLUMN
dbo	DPRSystemMappingRule	Name	OBJECT_OR_COLUMN
dbo	QBM_YParameterList		TYPE

Source excerpt

First extracted SQL definition lines from the exported source. Use the full source page for complete context.

Open full formatted source

1create function dbo.DPR_FTSystemMappingRuleEffect () returns @erg table (UID_DPRSystemMap varchar(38) collate database_default , UID_DPRSystemMappingRule
2 varchar(38) collate database_default , Name nvarchar(256) collate database_default ) with schemabinding as begin declare @lauf int declare @help dbo.QBM_YParameterList
3  insert into @help (Parameter1 , Parameter2 , ContentShort , Parameter3 ) select m.UID_DPRSystemMap, r.UID_DPRSystemMappingRule, r.Name, m.UID_BaseDPRSystemMap
4 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 @help
6 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.Parameter1
7  and b.ContentShort  = br.Name ) select @lauf = @@rowcount  update @help set Parameter3  = b.UID_BaseDPRSystemMap from @help m join dbo.DPRSystemMap b
8 on m.Parameter3  = b.UID_DPRSystemMap where isnull(m.Parameter3 , '') <> isnull(b.UID_BaseDPRSystemMap, '') select @lauf += @@rowcount  end  insert into
9 @erg (UID_DPRSystemMap, UID_DPRSystemMappingRule, Name) select Parameter1 , Parameter2 , ContentShort  from @help return end 
10

Module relation graph

Loading module relation graph…

Source-derived context

Generated from exported SQL module definitions plus read-only sandbox sys.objects/sys.parameters/sys.sql_expression_dependencies metadata. This is factual source evidence, not a semantic guess.

provenance: SQL definition export provenance: sandbox DB metadata modified: 2026-04-14T23:16:47.157

None extracted.

Summary: writes INSERT into; reads/joins DPRSystemMap, DPRSystemMappingRule

Declared parameters

No declared parameters in sys.parameters for this object, or metadata was not available.

DML targets

INSERT into

Called routines

None extracted.

Read/join references

SQL dependency metadata

Config/session

Config: None extracted.

Session: None extracted.

DBQueue/tasks

None extracted.

Temp tables / referenced variables

Temp: None extracted.

Variables: @erg @lauf @help @rowcount

Referenced by / reverse dependencies

Generated from live DB metadata, FK rows, and exported SQL dependency/source extraction. This is factual linkage evidence, not inferred behavior.

No reverse dependencies extracted.