Back to OIM Explorer

dbo.QER_FTQERReuseUSPredecessor

Table FunctionSQL_TABLE_VALUED_FUNCTIONSandbox DB

Table Function.

Source: sandbox-db sys.sql_modules

Source size: 1.069 characters

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

Complete Source

SQL43 lines
1CREATE FUNCTION dbo.QER_FTQERReuseUSPredecessor(2  @UID_QERReuseUS varchar(38)3) RETURNS @erg TABLE(UID_QERReuseUSPredecessor varchar(38) collate database_default,4UID_QERReuseUS varchar(38) collate database_default5)6  WITH schemabinding7AS8BEGIN9  DECLARE @UID_QERReuseUSSearch varchar(38)10  DECLARE @UID_QERReuseUSPredecessor varchar(38)11  SELECT @UID_QERReuseUSSearch = @UID_QERReuseUS12  INSERT INTO @erg(UID_QERReuseUSPredecessor,13  UID_QERReuseUS)14  SELECT15    @UID_QERReuseUS,16    @UID_QERReuseUS marke:17  SELECT @UID_QERReuseUSPredecessor = NULL18  SELECT TOP 1 @UID_QERReuseUSPredecessor = r.UID_QERReuseUSPredecessor19  FROM dbo.QERReuseUS r20  WHERE21    r.UID_QERReuseUS = @UID_QERReuseUSSearch22  IF @UID_QERReuseUSPredecessor > ' '23  BEGIN24    INSERT INTO @erg(UID_QERReuseUSPredecessor,25    UID_QERReuseUS)26    SELECT27      @UID_QERReuseUSPredecessor,28      @UID_QERReuseUS29    WHERE30      NOT EXISTS(31    SELECT TOP 1 132    FROM @erg e33    WHERE34      e.UID_QERReuseUSPredecessor = @UID_QERReuseUSPredecessor)35    IF @@ROWCOUNT > 036    BEGIN37      SELECT @UID_QERReuseUSSearch = @UID_QERReuseUSPredecessor38      GOTO marke39    END40  END41  EndLabel:42  RETURN43END
Open raw exported source
SQL ยท Raw8 lines
1create function dbo.QER_FTQERReuseUSPredecessor(@UID_QERReuseUS varchar(38) ) returns @erg table (UID_QERReuseUSPredecessor varchar(38) collate database_default2 , UID_QERReuseUS varchar(38) collate database_default ) with schemabinding as begin declare @UID_QERReuseUSSearch varchar(38) declare @UID_QERReuseUSPredecessor3 varchar(38) select @UID_QERReuseUSSearch = @UID_QERReuseUS insert into @erg (UID_QERReuseUSPredecessor, UID_QERReuseUS) select @UID_QERReuseUS, @UID_QERReuseUS4 marke: select @UID_QERReuseUSPredecessor = null select top 1 @UID_QERReuseUSPredecessor = r.UID_QERReuseUSPredecessor from dbo.QERReuseUS r where r.UID_QERReuseUS5 = @UID_QERReuseUSSearch if @UID_QERReuseUSPredecessor > ' ' begin insert into @erg (UID_QERReuseUSPredecessor, UID_QERReuseUS) select @UID_QERReuseUSPredecessor6, @UID_QERReuseUS where Not exists (select top 1 1 from @erg e where e.UID_QERReuseUSPredecessor = @UID_QERReuseUSPredecessor ) if @@ROWCOUNT > 0 begin7 select @UID_QERReuseUSSearch = @UID_QERReuseUSPredecessor goto marke end end EndLabel: return end 8