Back to OIM Explorer

dbo.QER_FTQERAssignPredecessor

Table FunctionSQL_TABLE_VALUED_FUNCTIONSandbox DB

Table Function.

Source: sandbox-db sys.sql_modules

Source size: 1.042 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_FTQERAssignPredecessor(2  @UID_QERAssign varchar(38)3) RETURNS @erg TABLE(UID_QERAssignPredecessor varchar(38) collate database_default,4UID_QERAssign varchar(38) collate database_default5)6  WITH schemabinding7AS8BEGIN9  DECLARE @UID_QERAssignSearch varchar(38)10  DECLARE @UID_QERAssignPredecessor varchar(38)11  SELECT @UID_QERAssignSearch = @UID_QERAssign12  INSERT INTO @erg(UID_QERAssignPredecessor,13  UID_QERAssign)14  SELECT15    @UID_QERAssign,16    @UID_QERAssign marke:17  SELECT @UID_QERAssignPredecessor = NULL18  SELECT TOP 1 @UID_QERAssignPredecessor = r.UID_QERAssignPredecessor19  FROM dbo.QERAssign r20  WHERE21    r.UID_QERAssign = @UID_QERAssignSearch22  IF @UID_QERAssignPredecessor > ' '23  BEGIN24    INSERT INTO @erg(UID_QERAssignPredecessor,25    UID_QERAssign)26    SELECT27      @UID_QERAssignPredecessor,28      @UID_QERAssign29    WHERE30      NOT EXISTS(31    SELECT TOP 1 132    FROM @erg e33    WHERE34      e.UID_QERAssignPredecessor = @UID_QERAssignPredecessor)35    IF @@ROWCOUNT > 036    BEGIN37      SELECT @UID_QERAssignSearch = @UID_QERAssignPredecessor38      GOTO marke39    END40  END41  EndLabel:42  RETURN43END
Open raw exported source
SQL ยท Raw8 lines
1create function dbo.QER_FTQERAssignPredecessor(@UID_QERAssign varchar(38) ) returns @erg table (UID_QERAssignPredecessor varchar(38) collate database_default2 , UID_QERAssign varchar(38) collate database_default ) with schemabinding as begin declare @UID_QERAssignSearch varchar(38) declare @UID_QERAssignPredecessor3 varchar(38) select @UID_QERAssignSearch = @UID_QERAssign insert into @erg (UID_QERAssignPredecessor, UID_QERAssign) select @UID_QERAssign, @UID_QERAssign4 marke: select @UID_QERAssignPredecessor = null select top 1 @UID_QERAssignPredecessor = r.UID_QERAssignPredecessor from dbo.QERAssign r where r.UID_QERAssign5 = @UID_QERAssignSearch if @UID_QERAssignPredecessor > ' ' begin insert into @erg (UID_QERAssignPredecessor, UID_QERAssign) select @UID_QERAssignPredecessor6, @UID_QERAssign where Not exists (select top 1 1 from @erg e where e.UID_QERAssignPredecessor = @UID_QERAssignPredecessor ) if @@ROWCOUNT > 0 begin select7 @UID_QERAssignSearch = @UID_QERAssignPredecessor goto marke end end EndLabel: return end 8