incrRate 增减比

CREATE FUNCTION dbo.incrRate(@val01 decimal(36,4),@val02 decimal(36,4))
RETURNS decimal(36,4)
AS
-- 增减比
BEGIN

DECLARE @re_val decimal(36,4)=null;

if isnull(@val01,0)=0 return @re_val;

set @re_val=round(1.0000*isnull(@val02,0)/@val01-1.0000,4);
   
RETURN @re_val;

END;