dbo.QER_FGIPersonHeadCirc

SQL_SCALAR_FUNCTION

Created 2025-06-27T17:59:27.410 · modified 2026-04-14T23:20:36.473 · source: live DB sys.objects/sys.sql_expression_dependencies.

Open formatted source/search result

Parameters

Name	Type	Output
	bit	yes
`@UID_Person`	varchar	no
`@UID_PersonHead`	varchar	no

Referenced objects

Schema	Object	Column/minor	Class
	HelperHeadPerson		OBJECT_OR_COLUMN
dbo	QBM_YCursorBuffer		TYPE

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_FGIPersonHeadCirc(@UID_Person varchar(38) , @UID_PersonHead varchar(38) ) returns bit as begin declare @erg bit = 0 declare
2 @work dbo.QBM_YCursorBuffer declare @lauf int insert into @work( UID1 , UID2 ) values (@UID_Person , @UID_PersonHead ) select @lauf = 1 while @lauf > 
30 begin insert into @work(UID1, UID2) select h.uid_person, h.uid_personhead from @work l join HelperHeadPerson h on l.UID2 = h.UID_Person where not exists
4 (select top 1 1 from @work e where e.UID1 = h.UID_Person and e.UID2 = h.uid_personhead ) select @lauf = @@ROWCOUNT end if exists (select top 1 1 from 
5@work where UID2 = @UID_Person) begin select @erg = 1 end else begin select @erg = 0 end 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:36.473

None extracted.

Summary: writes INSERT into; reads/joins HelperHeadPerson

Declared parameters

Parameter	Type	Direction
	`bit`	OUTPUT
`@UID_Person`	`varchar(38)`	input
`@UID_PersonHead`	`varchar(38)`	input

DML targets

INSERT into

Called routines

None extracted.

Read/join references

HelperHeadPerson

SQL dependency metadata

Config/session

Config: None extracted.

Session: None extracted.

DBQueue/tasks

None extracted.

Temp tables / referenced variables

Temp: None extracted.

Variables: @UID_Person @UID_PersonHead @erg @work @lauf @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.