dbo.QBM_FGIBitPatternXOrigin
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.QBM_FSQFKCheckFix
- dbo.QBM_FSQTriggerWatchXOrigin
- dbo.ADS_ZAccountInADSGroup
- dbo.ADS_ZADSMachineInADSGroup
- dbo.ADS_ZContactInADSGroup
- dbo.ADS_ZOrgHasADSGroup
- dbo.CPL_PComplianceCheckMakeProc_h
- dbo.LDP_ZAccountInLDAPGroup
- dbo.LDP_ZBaseTreeHasObject
- dbo.LDP_ZLDPMachineInLDAPGroup
- dbo.LDP_ZOrgHasLDAPGroup
- dbo.QBM_PMNTableOriginUpdate
- dbo.QBM_ZGroupCollection
- dbo.QER_PAssignmentCheckValid
- dbo.QER_PDynamicGroupMakeProc_hlp
- dbo.QER_PITShopOrderMove_bulk
- dbo.QER_PITShopProductNodeCheck
- dbo.QER_ZAllForPersonInBaseTree
- dbo.QER_ZBaseTreeHasObject
- dbo.QER_ZHelperHeadOrg
- dbo.QER_ZHelperHeadPerson
- dbo.QER_ZOrgHasQERAssign
- dbo.QER_ZOrgHasQERResource
- dbo.QER_ZOrgHasQERReuse
- dbo.QER_ZOrgHasQERReuseUS
- dbo.QER_ZPersonHasQERAssign
- dbo.QER_ZPersonHasQERResource
- dbo.QER_ZPersonHasQERReuse
- dbo.QER_ZPersonHasQERReuseUS
- dbo.RMS_ZESetCollection
- dbo.RMS_ZESetHasEntitlement
- dbo.RMS_ZOrgHasESet
- dbo.RMS_ZPersonHasESet
- dbo.RMS_ZWorkDeskHasESet
- dbo.RPS_ZBaseTreeHasObject
- dbo.RPS_ZOrgHasRPSReport
- dbo.RPS_ZPersonHasRPSReport
- dbo.TSB_PMemberOfSplitToGroups
- dbo.TSB_PUNSAccountBInUNSGroupB_K
- dbo.TSB_PUNSAccountBInUNSGroupB1_K
- dbo.TSB_PUNSAccountBInUNSGroupB2_K
- dbo.TSB_PUNSAccountBInUNSGroupB3_K
- dbo.TSB_ZBaseTreeHasObject
- dbo.TSB_ZOrgHasTSBAccountDef
- dbo.TSB_ZOrgHasUNSGroupB
- dbo.TSB_ZOrgHasUNSGroupB1
- dbo.TSB_ZOrgHasUNSGroupB2
- dbo.TSB_ZOrgHasUNSGroupB3
- dbo.TSB_ZPersonHasTSBAccountDef
- dbo.TSB_ZUNSAccountBHasUNSItemB
- dbo.TSB_ZUNSGroupBHasUNSItemB
- dbo.QER_FTPersonHeadCirc_All
- dbo.QER_FTPersonHeadCirc_Person_i
- dbo.ADS_TIADSAccountInADSGroup
- dbo.ADS_TIADSContactInADSGroup
- dbo.ADS_TIADSMachineInADSGroup
- dbo.ADS_TIBaseTreeHasADSGroup
- dbo.ADS_TUADSAccount
- dbo.ADS_TUADSMachine
- dbo.CPL_TUComplianceRule
Complete Source
1CREATE FUNCTION dbo.QBM_FGIBitPatternXOrigin(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('Direct', 1),('Inherit', 2),('Dynamic', 4),('PWO', 8),('Special', 16),('Extern', 32),('', 0)) AS v(xkey,16 xvalue)17 JOIN string_split(isnull(@PatternNames, ''), '|') AS s18 ON v.xkey = s.value)19ENDOpen raw exported source
1 create function dbo.QBM_FGIBitPatternXOrigin( @PatternNames nvarchar(256) , @AllExceptThis bit ) returns int with SCHEMABINDING as begin2 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