Back to OIM Explorer

dbo.QER_FGIPersonHeadCirc

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

Source size: 721 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

  • No direct source references extracted.

Complete Source

SQL46 lines
1CREATE FUNCTION dbo.QER_FGIPersonHeadCirc(2  @UID_Person varchar(38),3  @UID_PersonHead varchar(38)4) RETURNS BIT5AS6BEGIN7  DECLARE @erg BIT = 08  DECLARE @work dbo.QBM_YCursorBuffer9  DECLARE @lauf int10  INSERT INTO @work(UID1,11  UID2)12  VALUES(@UID_Person,13  @UID_PersonHead)14  SELECT @lauf = 115  WHILE @lauf > 016  BEGIN17    INSERT INTO @work(UID1,18    UID2)19    SELECT20      h.uid_person,21      h.uid_personhead22    FROM @work l23    JOIN HelperHeadPerson h24      ON l.UID2 = h.UID_Person25    WHERE26      NOT EXISTS(27    SELECT TOP 1 128    FROM @work e29    WHERE30      e.UID1 = h.UID_Person AND e.UID2 = h.uid_personhead)31    SELECT @lauf = @@ROWCOUNT32  END33  IF EXISTS(34    SELECT TOP 1 135    FROM @work36    WHERE37      UID2 = @UID_Person)38  BEGIN39    SELECT @erg = 140  END41  ELSE42  BEGIN43    SELECT @erg = 044  END45  RETURN @erg46END
Open raw exported source
SQL ยท Raw6 lines
1 create   function dbo.QER_FGIPersonHeadCirc(@UID_Person varchar(38) , @UID_PersonHead varchar(38) ) returns bit as begin declare @erg bit = 0 declare2 @work dbo.QBM_YCursorBuffer declare @lauf int insert into @work( UID1 , UID2 ) values (@UID_Person , @UID_PersonHead ) select @lauf = 1 while @lauf > 30 begin insert into @work(UID1, UID2) select h.uid_person, h.uid_personhead from @work l join HelperHeadPerson h on l.UID2 = h.UID_Person where not exists4 (select top 1 1 from @work e where e.UID1 = h.UID_Person and e.UID2 = h.uid_personhead ) select @lauf = @@ROWCOUNT end if exists (select top 1 1 from 5@work where UID2 = @UID_Person) begin select @erg = 1 end else begin select @erg = 0 end return @erg end 6