dbo.QBM_FGIBitPatternXMarkedForDel
Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB
Interpretation
- Database function. Usually supports views, validation, or calculated predicates; look at referenced-by entries for callers.
Relations
- No extracted relations.
Typed Edges
- No typed edges extracted for this source.
References
- No direct source references extracted.
Referenced By
- dbo.DPR_FSQTriggerWatchMemberShip
- dbo.QBM_FSQTriggerWatchXOrigin
- dbo.QBM_FSQXDateSubItemUpdate
- dbo.QBM_FSQXMarkedForDeletionChg
- dbo.ADS_ZAccountInADSGroup
- dbo.ADS_ZADSMachineInADSGroup
- dbo.ADS_ZContactInADSGroup
- dbo.ADS_ZPersonHasObject
- dbo.CPL_PComplianceCheckMakeProc_h
- dbo.CPL_ZITShopMakeDecisionOC
- dbo.CPL_ZITShopMakeDecisionOH
- dbo.LDP_RLDPMachineInLDAPGroup
- dbo.LDP_ZAccountInLDAPGroup
- dbo.LDP_ZLDPMachineInLDAPGroup
- dbo.LDP_ZPersonHasObject
- dbo.QBM_PSlotResetOnMissingItem_L
- dbo.QBM_PXDateSubItemUpdate
- dbo.QBM_ZXMarkedForDeletionPush
- dbo.QER_PDynamicGroupMakeProc_hlp
- dbo.QER_PITShopHelperFill_bulk
- dbo.TSB_PUNSAccountBInUNSGroupB_K
- dbo.TSB_PUNSAccountBInUNSGroupB1_K
- dbo.TSB_PUNSAccountBInUNSGroupB2_K
- dbo.TSB_PUNSAccountBInUNSGroupB3_K
- dbo.TSB_ZPersonHasObject
- dbo.ADS_TDADSGroupInADSGroup
- dbo.ADS_TUADSAccount
- dbo.ADS_TUADSAccountInADSGroup
- dbo.ADS_TUADSContact
- dbo.ADS_TUADSContactInADSGroup
- dbo.ADS_TUAdsGroup
- dbo.ADS_TUADSMachineInADSGroup
- dbo.CPL_TUPerson
- dbo.LDP_TULDAPAccount
- dbo.LDP_TULDAPAccountInLDAPGroup
- dbo.LDP_TULDAPGroup
- dbo.QER_TUHardware
- dbo.QER_TUPerson
- dbo.TSB_TUUNSAccountB
- dbo.TSB_TUUNSAccountBInUNSGroupB
- dbo.TSB_TUUNSAccountBInUNSGroupB1
- dbo.TSB_TUUNSAccountBInUNSGroupB2
- dbo.TSB_TUUNSAccountBInUNSGroupB3
- dbo.TSB_TUUNSGroupB
- dbo.TSB_TUUNSGroupB1
- dbo.TSB_TUUNSGroupB2
- dbo.TSB_TUUNSGroupB3
Complete Source
1CREATE FUNCTION dbo.QBM_FGIBitPatternXMarkedForDel(2 @PatternNames nvarchar(256),3 @AllExceptThis BIT4) RETURNS int5 WITH SCHEMABINDING6AS7BEGIN8 RETURN(9 SELECT CASE @AllExceptThis10 WHEN 0 THEN11 SUM(DISTINCT v.xvalue)12 ELSE ~ SUM(DISTINCT v.xvalue)13 END14 FROM(15 VALUES('Delay', 1),('OutStanding', 2),('QBMLock', 4),('Publishing', 8),('', 0)) AS v(xkey, xvalue)16 JOIN string_split(isnull(@PatternNames, ''), '|') AS s17 ON v.xkey = s.value)18ENDOpen raw exported source
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