dbo.QBM_FGIBitPatternXOrigin

SQL_SCALAR_FUNCTION

Created 2025-06-27T17:57:01.647 · modified 2026-04-14T23:14:10.550 · 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.QBM_FGIBitPatternXOrigin( @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', 2) ,
3 ('Dynamic', 4) , ('PWO', 8) , ('Special', 16) , ('Extern', 32) , ('', 0) ) as v (xkey, xvalue) join string_split(isnull(@PatternNames, ''), '|') as s 
4on v.xkey = s.value ) end 
5

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:14:10.550

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.QBM_FSQFKCheckFix	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.QBM_FSQTriggerWatchXOrigin	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.ADS_ZAccountInADSGroup	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.ADS_ZADSMachineInADSGroup	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.ADS_ZContactInADSGroup	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.ADS_ZOrgHasADSGroup	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.CPL_PComplianceCheckMakeProc_h	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.LDP_ZAccountInLDAPGroup	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.LDP_ZBaseTreeHasObject	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.LDP_ZLDPMachineInLDAPGroup	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.LDP_ZOrgHasLDAPGroup	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.QBM_PMNTableOriginUpdate	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.QBM_ZGroupCollection	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.QER_PAssignmentCheckValid	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.QER_PDynamicGroupMakeProc_hlp	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.QER_PITShopOrderMove_bulk	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.QER_PITShopProductNodeCheck	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.QER_ZAllForPersonInBaseTree	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.QER_ZBaseTreeHasObject	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.QER_ZHelperHeadOrg	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.QER_ZHelperHeadPerson	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.QER_ZOrgHasQERAssign	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.QER_ZOrgHasQERResource	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.QER_ZOrgHasQERReuse	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.QER_ZOrgHasQERReuseUS	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.QER_ZPersonHasQERAssign	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.QER_ZPersonHasQERResource	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.QER_ZPersonHasQERReuse	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.QER_ZPersonHasQERReuseUS	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.RMS_ZESetCollection	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.RMS_ZESetHasEntitlement	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.RMS_ZOrgHasESet	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.RMS_ZPersonHasESet	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.RMS_ZWorkDeskHasESet	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.RPS_ZBaseTreeHasObject	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.RPS_ZOrgHasRPSReport	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.RPS_ZPersonHasRPSReport	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.TSB_PMemberOfSplitToGroups	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.TSB_PUNSAccountBInUNSGroupB_K	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.TSB_PUNSAccountBInUNSGroupB1_K	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.TSB_PUNSAccountBInUNSGroupB2_K	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.TSB_PUNSAccountBInUNSGroupB3_K	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.TSB_ZBaseTreeHasObject	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.TSB_ZOrgHasTSBAccountDef	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.TSB_ZOrgHasUNSGroupB	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.TSB_ZOrgHasUNSGroupB1	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.TSB_ZOrgHasUNSGroupB2	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.TSB_ZOrgHasUNSGroupB3	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.TSB_ZPersonHasTSBAccountDef	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.TSB_ZUNSAccountBHasUNSItemB	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.TSB_ZUNSGroupBHasUNSItemB	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.QER_FTPersonHeadCirc_All	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.QER_FTPersonHeadCirc_Person_i	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.ADS_TIADSAccountInADSGroup	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.ADS_TIADSContactInADSGroup	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.ADS_TIADSMachineInADSGroup	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.ADS_TIBaseTreeHasADSGroup	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.ADS_TUADSAccount	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.ADS_TUADSMachine	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.CPL_TUComplianceRule	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.LDP_TIBaseTreeHasLDAPGroup	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.LDP_TILDAPAccountInLDAPGroup	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.LDP_TILDPMachineInLDAPGroup	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.QER_TDDynamicGroup	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.QER_TIBaseTreeHasQERAssign	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.QER_TIBaseTreeHasQERResource	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.QER_TIBaseTreeHasQERReuse	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.QER_TIBaseTreeHasQERReuseUS	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.QER_TIPersonHasQERAssign	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.QER_TIPersonHasQERResource	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.QER_TIPersonHasQERReuse	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.QER_TIPersonHasQERReuseUS	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.QER_TIPersonInBaseTree	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.QER_TUDynamicGroup	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.QER_TUOrgRootAssign	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.RMS_TIBaseTreeHasESet	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.RMS_TIESetHasEntitlement	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.RMS_TIPersonHasESet	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.RMS_TIWorkDeskHasESet	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.RMS_TUESetHasEntitlement	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.RPS_TIBaseTreeHasRPSReport	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.RPS_TIPersonHasRPSReport	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.TSB_TIBaseTreeHasTSBAccountDef	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.TSB_TIBaseTreeHasUNSGroupB	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.TSB_TIBaseTreeHasUNSGroupB1	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.TSB_TIBaseTreeHasUNSGroupB2	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.TSB_TIBaseTreeHasUNSGroupB3	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.TSB_TIPersonHasTSBAccountDef	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.TSB_TIUNSAccountBHasUNSGroupB	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.TSB_TIUNSAccountBHasUNSGroupB1	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.TSB_TIUNSAccountBHasUNSGroupB2	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.TSB_TIUNSAccountBHasUNSGroupB3	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.TSB_TIUNSAccountBHasUNSItemB	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.TSB_TIUNSAccountBInUNSGroupB	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.TSB_TIUNSAccountBInUNSGroupB1	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.TSB_TIUNSAccountBInUNSGroupB2	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.TSB_TIUNSAccountBInUNSGroupB3	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.TSB_TIUNSGroupBHasUNSItemB	SQL expression dependency	dbo · OBJECT_OR_COLUMN