Back to OIM Explorer

dbo.QER_FGIPWOStateFinalError

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

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

SQL20 lines
1CREATE FUNCTION dbo.QER_FGIPWOStateFinalError(2  @UID_PersonWantsOrg varchar(38)3) RETURNS varchar(384)5  WITH schemabinding6AS7BEGIN8  DECLARE @UID_PWOStateFinalError varchar(38) = NULL9  SELECT TOP 1 @UID_PWOStateFinalError = s.UID_PWOStateFinalError10  FROM dbo.PersonWantsOrg pwo11  JOIN dbo.QERWorkingStep s12    ON s.UID_QERWorkingMethod = pwo.UID_QERWorkingMethod AND pwo.decisionlevel = s.levelnumber AND s.SubLevelNumber = 013  WHERE14    pwo.uid_personwantsorg = @UID_PersonWantsOrg15  IF @UID_PWOStateFinalError IS NULL16  BEGIN17    SELECT @UID_PWOStateFinalError = ''18  END19  RETURN(@UID_PWOStateFinalError)20END
Open raw exported source
SQL ยท Raw5 lines
1   create   function dbo.QER_FGIPWOStateFinalError (@UID_PersonWantsOrg varchar(38) ) returns varchar(38) with schemabinding as begin declare @UID_PWOStateFinalError2 varchar(38) = null select top 1 @UID_PWOStateFinalError = s.UID_PWOStateFinalError from dbo.PersonWantsOrg pwo join dbo.QERWorkingStep s on s.UID_QERWorkingMethod3 = pwo.UID_QERWorkingMethod and pwo.decisionlevel = s.levelnumber and s.SubLevelNumber = 0 where pwo.uid_personwantsorg = @UID_PersonWantsOrg if @UID_PWOStateFinalError4 is null begin select @UID_PWOStateFinalError = '' end return (@UID_PWOStateFinalError) end 5