Back to OIM Explorer

dbo.QER_FGIPWORulerOriginALL

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

Source size: 523 characters

Interpretation

  • Database function. Usually supports views, validation, or calculated predicates; look at referenced-by entries for callers.

Relations

  • No extracted relations.

Typed Edges

  • references source dbo.QER_FGIPWORulerOrigin source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL28 lines
1CREATE FUNCTION dbo.QER_FGIPWORulerOriginALL(2  @Objectkey varchar(138)3) RETURNS varchar(384)5AS6BEGIN7  DECLARE @erg varchar(38) = NULL8  IF isnull(@Objectkey,9  '') = ''10  BEGIN11    RETURN(@erg)12  END13  SELECT TOP 1 @erg = pwo.UID_PersonWantsOrg14  FROM PersonWantsOrg pwo15  JOIN QER_VPWOOrderState s16    ON pwo.OrderState = s.OrderState17  WHERE18    pwo.ObjectKeyAssignment = @Objectkey19  ORDER BY s.IsAssigned DESC,20  s.IsGranted DESC,21  s.IsOrder DESC,22  s.IsClosed ASC endLabel:23  IF @erg = ''24  BEGIN25    SELECT @erg = NULL26  END27  RETURN(@erg)28END
Open raw exported source
SQL ยท Raw5 lines
1   create   function dbo.QER_FGIPWORulerOriginALL(@Objectkey varchar(138)  ) returns varchar(38) as begin declare @erg varchar(38) = null if isnull2(@Objectkey, '') = '' begin   return(@erg)  end select top 1 @erg = pwo.UID_PersonWantsOrg from PersonWantsOrg pwo join QER_VPWOOrderState  s on pwo.OrderState3 = s.OrderState where pwo.ObjectKeyAssignment = @Objectkey  order by s.IsAssigned desc, s.IsGranted desc , s.IsOrder desc , s.IsClosed asc endLabel: if4 @erg = '' begin select @erg = null end return (@erg) end 5