ratio 均价、占比

CREATE FUNCTION dbo.ratio(@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,4);
   
RETURN @re_val;

END;