pears.TempRatePrecision
Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
Original SQL
COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."TempRatePrecision" IS {CREATE FUNCTION TempRatePrecision /* Application Maintained Function / Procedure - DO NOT EDIT*/ (IN TempUnits NUMERIC) RETURNS NUMERIC BEGIN DECLARE rv NUMERIC; SELECT IF isnull(TmpRatePrecision,0)=2 THEN iqmoneyround(TempUnits) ELSE round(TempUnits, TmpRatePrecision) END IF INTO rv; RETURN rv; END }