Back to OIM Explorer

dbo.QBM_FCVStringToListItem

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

Source size: 651 characters

Interpretation

  • Database function. Usually supports views, validation, or calculated predicates; look at referenced-by entries for callers.

Relations

  • No extracted relations.

Typed Edges

  • references source dbo.QBM_FCVStringToList source text reference

References

Referenced By

Complete Source

SQL34 lines
1CREATE FUNCTION dbo.QBM_FCVStringToListItem(2  @InString nvarchar(max),3  @Delimiter nvarchar(64),4  @SuppressEmpty BIT,5  @ElementToDeliver int,6  @CaseSensitive BIT = 07) RETURNS nvarchar(max8)9AS10BEGIN11  DECLARE @erg nvarchar(max)12  IF @ElementToDeliver > 013  BEGIN14    SELECT TOP 1 @erg = x.parametervalue15    FROM dbo.QBM_FCVStringToList(@InString,16    @Delimiter,17    @SuppressEmpty,18    @CaseSensitive) x19    WHERE20      x.ordernumber = @ElementToDeliver21  END22  ELSE23  BEGIN24    SELECT TOP 1 @erg = x.parametervalue25    FROM dbo.QBM_FCVStringToList(@InString,26    @Delimiter,27    @SuppressEmpty,28    @CaseSensitive) x29    WHERE30      x.ordernumberReverse = abs(@ElementToDeliver)31  END32  ende:33  RETURN(@erg)34END
Open raw exported source
SQL ยท Raw6 lines
1   create   function dbo.QBM_FCVStringToListItem(@InString nvarchar(max) , @Delimiter nvarchar(64) , @SuppressEmpty bit , @ElementToDeliver int 2, @CaseSensitive bit = 0 ) returns nvarchar(max) as begin declare @erg nvarchar(max) if @ElementToDeliver > 0 begin select top 1 @erg = x.parametervalue3 from dbo.QBM_FCVStringToList(@InString, @Delimiter, @SuppressEmpty, @CaseSensitive) x where x.ordernumber = @ElementToDeliver end else begin select top4 1 @erg = x.parametervalue from dbo.QBM_FCVStringToList(@InString, @Delimiter, @SuppressEmpty, @CaseSensitive) x where x.ordernumberReverse = abs(@ElementToDeliver5) end ende: return (@erg) end 6