====== 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 }