dbo.QER_FGIBitPatternInheritInfo

SQL_SCALAR_FUNCTION

Created 2025-06-27T17:59:26.750 · modified 2026-04-14T23:17:26.313 · source: live DB sys.objects/sys.sql_expression_dependencies.

Open formatted source/search result

Parameters

Name	Type	Output
	int	yes
`@PatternNames`	nvarchar	no
`@AllExceptThis`	bit	no

Referenced objects

Schema	Object	Column/minor	Class
No SQL expression dependencies in snapshot.

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_FGIBitPatternInheritInfo( @PatternNames nvarchar(256)  , @AllExceptThis bit  ) returns int with SCHEMABINDING as begin
2 return (    select  case @AllExceptThis when 0 then SUM(distinct v.xvalue) else ~ SUM(distinct v.xvalue) end from ( values ('Direct', 1  ) , ('Inherit'
3, 2  ) , ('Master', 4) , ('', 0) ) as v (xkey, xvalue) join string_split(isnull(@PatternNames, ''), '|') as s on v.xkey = s.value     ) end 
4

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:17:26.313

None extracted.

Summary: reads/joins string_split

Declared parameters

Parameter	Type	Direction
	`int`	OUTPUT
`@PatternNames`	`nvarchar(256)`	input
`@AllExceptThis`	`bit`	input

DML targets

None extracted.

Called routines

None extracted.

Read/join references

string_split

SQL dependency metadata

None extracted.

Config/session

Config: None extracted.

Session: None extracted.

DBQueue/tasks

None extracted.

Temp tables / referenced variables

Temp: None extracted.

Variables: @PatternNames @AllExceptThis

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.

Referencing object	Relation	Evidence
dbo.QER_FGIPwoValidDateRangesExist	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.ADS_ZBaseTreeHasObject	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.ADS_ZPersonHasObject	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.CPL_PComplianceCheckMakeProc_h	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.LDP_ZBaseTreeHasObject	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.LDP_ZPersonHasObject	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.QER_PITShopProductNodeCreate_b	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.QER_PITShopProductNodeMove	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.QER_ZBaseTreeHasObjectExtAtt	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.QER_ZPersonHasObject	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.QER_ZPersonHasObjectExtAtt	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.RMS_ZBaseTreeHasObject	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.RMS_ZPersonHasObject	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.RPS_ZPersonHasObject	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.TSB_ZBaseTreeHasObject	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.TSB_ZPersonHasObject	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.QER_FTPwoValidDateRanges	SQL expression dependency	dbo · OBJECT_OR_COLUMN