Back to OIM Explorer

dbo.QER_FGIPWORulerOrigin

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

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

SQL26 lines
1CREATE FUNCTION dbo.QER_FGIPWORulerOrigin(2  @Objectkey varchar(138)3) RETURNS varchar(384)5  WITH schemabinding6AS7BEGIN8  DECLARE @erg varchar(38) = NULL9  IF isnull(@Objectkey,10  '') = ''11  BEGIN12    RETURN(@erg)13  END14  SELECT TOP 1 @erg = pwo.UID_PersonWantsOrg15  FROM dbo.PersonWantsOrg pwo16  WHERE17    pwo.ObjectKeyAssignment = @Objectkey AND pwo.OrderState IN('Assigned',18  'OrderProlongate',19  'OrderUnsubscribe')20  ORDER BY pwo.DateActivated ASC endLabel:21  IF @erg = ''22  BEGIN23    SELECT @erg = NULL24  END25  RETURN(@erg)26END
Open raw exported source
SQL ยท Raw5 lines
1  create   function dbo.QER_FGIPWORulerOrigin(@Objectkey varchar(138)  ) returns varchar(38) with schemabinding as begin declare @erg varchar(382) = null if isnull(@Objectkey, '') = '' begin   return(@erg)  end select top 1 @erg = pwo.UID_PersonWantsOrg  from dbo.PersonWantsOrg pwo  where pwo.ObjectKeyAssignment3 = @Objectkey  and pwo.OrderState in ('Assigned', 'OrderProlongate', 'OrderUnsubscribe' )  order by pwo.DateActivated asc endLabel: if @erg = '' begin 4select @erg = null end return (@erg) end 5