dbo.QBM_FGIBitPatternXMarkedForDel
SQL_SCALAR_FUNCTION
Created 2025-06-27T17:57:01.640 · modified 2026-04-14T23:14:10.547 · source: live DB sys.objects/sys.sql_expression_dependencies.
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.
1 create function dbo.QBM_FGIBitPatternXMarkedForDel( @PatternNames nvarchar(256) , @AllExceptThis bit ) returns int with SCHEMABINDING 2as begin return( select case @AllExceptThis when 0 then SUM(distinct v.xvalue) else ~ SUM(distinct v.xvalue) end from ( values ('Delay', 1) , ('OutStanding' 3, 2) , ('QBMLock', 4) , ('Publishing', 8) , ('', 0) ) as v (xkey, xvalue) join string_split(isnull(@PatternNames, ''), '|') as s on v.xkey = s.value ) 4end 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.547
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
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.DPR_FSQTriggerWatchMemberShip | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QBM_FSQTriggerWatchXOrigin | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QBM_FSQXDateSubItemUpdate | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QBM_FSQXMarkedForDeletionChg | 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_ZPersonHasObject | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.CPL_PComplianceCheckMakeProc_h | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.CPL_ZITShopMakeDecisionOC | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.CPL_ZITShopMakeDecisionOH | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.LDP_RLDPMachineInLDAPGroup | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.LDP_ZAccountInLDAPGroup | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.LDP_ZLDPMachineInLDAPGroup | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.LDP_ZPersonHasObject | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QBM_PSlotResetOnMissingItem_L | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QBM_PXDateSubItemUpdate | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QBM_ZXMarkedForDeletionPush | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QER_PDynamicGroupMakeProc_hlp | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QER_PITShopHelperFill_bulk | 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_ZPersonHasObject | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.ADS_TDADSGroupInADSGroup | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.ADS_TUADSAccount | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.ADS_TUADSAccountInADSGroup | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.ADS_TUADSContact | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.ADS_TUADSContactInADSGroup | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.ADS_TUAdsGroup | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.ADS_TUADSMachineInADSGroup | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.CPL_TUPerson | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.LDP_TULDAPAccount | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.LDP_TULDAPAccountInLDAPGroup | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.LDP_TULDAPGroup | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QER_TUHardware | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QER_TUPerson | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.TSB_TUUNSAccountB | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.TSB_TUUNSAccountBInUNSGroupB | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.TSB_TUUNSAccountBInUNSGroupB1 | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.TSB_TUUNSAccountBInUNSGroupB2 | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.TSB_TUUNSAccountBInUNSGroupB3 | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.TSB_TUUNSGroupB | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.TSB_TUUNSGroupB1 | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.TSB_TUUNSGroupB2 | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.TSB_TUUNSGroupB3 | SQL expression dependency | dbo · OBJECT_OR_COLUMN |