dbo.QER_FGIAERoleValidForGroup

SQL_SCALAR_FUNCTION

Created 2025-06-27T18:01:04.457 · modified 2026-04-14T23:20:35.867 · source: live DB sys.objects/sys.sql_expression_dependencies.

Open formatted source/search result

Parameters

Name	Type	Output
	int	yes
`@uid_AERole`	varchar	no
`@groupname`	nvarchar	no

Referenced objects

Schema	Object	Column/minor	Class
	AERole		OBJECT_OR_COLUMN
	DialogGroup		OBJECT_OR_COLUMN

Source excerpt

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

Open full formatted source

1   create   function dbo.QER_FGIAERoleValidForGroup ( @uid_AERole varchar(38), @groupname nvarchar(64) ) returns int as begin declare @erg int declare
2 @uid_AERole_intern varchar(38) declare @UID_ParentAERole varchar(38) declare @groupname_ist nvarchar(64) select @uid_AERole_intern = @uid_AERole select
3 @erg = 0 marke: select top 1 @groupname_ist = g.GroupName, @UID_ParentAERole = ae.UID_ParentAERole from AERole ae left outer join DialogGroup g on ae.UID_DialogGroup
4 = g.UID_DialogGroup where ae.UID_AERole = @uid_AERole_intern if @groupname_ist > ' ' begin if @groupname_ist = @Groupname begin select @erg = 1 goto ende
5 end end else begin  if @UID_ParentAERole > ' ' begin  select @uid_AERole_intern = @UID_ParentAERole goto marke end end ende: return(@erg) end 
6

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:20:35.867

None extracted.

Summary: reads/joins AERole, DialogGroup

Declared parameters

Parameter	Type	Direction
	`int`	OUTPUT
`@uid_AERole`	`varchar(38)`	input
`@groupname`	`nvarchar(64)`	input

DML targets

None extracted.

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: @uid_AERole @groupname @erg @uid_AERole_intern @UID_ParentAERole @groupname_ist @Groupname

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.