dbo.QBM_FCVStringToBit
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_FCVListToJobParameter
- dbo.QBM_FSQCVBufferToColumn
- dbo.CPL_ZITShopMakeDecisionCR
- dbo.CPL_ZITShopMakeDecisionOC
- dbo.CPL_ZITShopMakeDecisionOH
- dbo.QER_PIsForITShopFlagCheck
- dbo.QER_PITShopHelperFill_bulk
- dbo.QER_PITShopHelperFillAll
- dbo.QER_PITShopOrderMove_bulk
- dbo.QER_ZAllForPersonInBaseTree
- dbo.QER_ZITShopCheck
- dbo.QER_ZITShopCheckDecision
- dbo.QER_ZITShopCheckValid
- dbo.QER_ZITShopCheckWaiting
- dbo.QER_ZITShopDeleteClosed
- dbo.QER_ZITShopHelperFill_Recalc
- dbo.QER_ZITShopMakeDecisionCD
- dbo.QER_ZITShopMakeDecisionEX
- dbo.QER_ZITShopMakeDecisionRI
- dbo.QER_ZITShopMakeDecisionSB
- dbo.QER_ZITShopMakeDecisionWC
- dbo.QER_ZITShopOrderAbort
- dbo.QER_ZITShopRepairClosed
- dbo.QBM_FTSessionError_Split
- dbo.QER_FTPWOVisibleForPerson_I
- dbo.QER_TUHelperHeadOrg
- dbo.QER_TUHelperHeadPerson
- dbo.QER_TUPersonInBaseTree
- dbo.QER_TUPersonWantsOrg
Complete Source
1CREATE FUNCTION dbo.QBM_FCVStringToBit(2 @InputValue nvarchar(64)3) RETURNS BIT4 WITH SCHEMABINDING5AS6BEGIN7 RETURN(CASE8 LEFT(trim(isnull(@InputValue, '')), 4)9 WHEN N 'True' THEN10 111 WHEN N 'Wahr' THEN12 113 ELSE CASE14 WHEN15 LEFT(trim(isnull(@InputValue, '')), 1) = N '1' THEN16 117 WHEN18 LEFT(trim(isnull(@InputValue, '')), 2) = N 'ON' THEN19 120 ELSE 021 END22 END)23ENDOpen raw exported source
1 create function dbo.QBM_FCVStringToBit (@InputValue nvarchar(64)) returns bit with SCHEMABINDING as begin return( case left(trim(isnull(@InputValue2, '')), 4) when N'True' then 1 when N'Wahr' then 1 else case when left(trim(isnull(@InputValue, '')), 1) = N'1' then 1 when left(trim(isnull(@InputValue3, '')), 2) = N'ON' then 1 else 0 end end ) end 4