Back to OIM Explorer

dbo.QER_FTQERResourcePredecessor

Table FunctionSQL_TABLE_VALUED_FUNCTIONSandbox DB

Table Function.

Source: sandbox-db sys.sql_modules

Source size: 1.096 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_FTQERResourcePredecessor(2  @UID_QERResource varchar(38)3) RETURNS @erg TABLE(UID_QERResource varchar(38) collate database_default,4UID_QERResourcePredecessor varchar(38) collate database_default5)6  WITH schemabinding7AS8BEGIN9  DECLARE @UID_QERResourceSearch varchar(38)10  DECLARE @UID_QERResourcePredecessor varchar(38)11  SELECT @UID_QERResourceSearch = @UID_QERResource12  INSERT INTO @erg(UID_QERResourcePredecessor,13  UID_QERResource)14  SELECT15    @UID_QERResource,16    @UID_QERResource marke:17  SELECT @UID_QERResourcePredecessor = NULL18  SELECT TOP 1 @UID_QERResourcePredecessor = r.UID_QERResourcePredecessor19  FROM dbo.QERResource r20  WHERE21    r.UID_QERResource = @UID_QERResourceSearch22  IF @UID_QERResourcePredecessor > ' '23  BEGIN24    INSERT INTO @erg(UID_QERResourcePredecessor,25    UID_QERResource)26    SELECT27      @UID_QERResourcePredecessor,28      @UID_QERResource29    WHERE30      NOT EXISTS(31    SELECT TOP 1 132    FROM @erg e33    WHERE34      e.UID_QERResourcePredecessor = @UID_QERResourcePredecessor)35    IF @@ROWCOUNT > 036    BEGIN37      SELECT @UID_QERResourceSearch = @UID_QERResourcePredecessor38      GOTO marke39    END40  END41  EndLabel:42  RETURN43END
Open raw exported source
SQL ยท Raw8 lines
1create function dbo.QER_FTQERResourcePredecessor(@UID_QERResource varchar(38) ) returns @erg table (UID_QERResource varchar(38) collate database_default2 , UID_QERResourcePredecessor varchar(38) collate database_default ) with schemabinding as begin declare @UID_QERResourceSearch varchar(38) declare @UID_QERResourcePredecessor3 varchar(38) select @UID_QERResourceSearch = @UID_QERResource insert into @erg (UID_QERResourcePredecessor, UID_QERResource) select @UID_QERResource, @UID_QERResource4 marke: select @UID_QERResourcePredecessor = null select top 1 @UID_QERResourcePredecessor = r.UID_QERResourcePredecessor from dbo.QERResource r where 5r.UID_QERResource = @UID_QERResourceSearch if @UID_QERResourcePredecessor > ' ' begin insert into @erg (UID_QERResourcePredecessor, UID_QERResource) select6 @UID_QERResourcePredecessor, @UID_QERResource where Not exists (select top 1 1 from @erg e where e.UID_QERResourcePredecessor = @UID_QERResourcePredecessor7 ) if @@ROWCOUNT > 0 begin select @UID_QERResourceSearch = @UID_QERResourcePredecessor goto marke end end EndLabel: return end 8