SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE FUNCTION [dbo].[udf_Rate]
(
@Numerator DECIMAL(18,6),
@Denominator DECIMAL(18,6)
)
RETURNS DECIMAL(18,6)
AS
BEGIN
DECLARE @ReturnValue DECIMAL(18,6)
SELECT @ReturnValue=(CASE WHEN @Denominator = 0 THEN NULL WHEN @Denominator IS NULL THEN NULL WHEN @Denominator <> 0 THEN (ISNULL(@Numerator,0) / @Denominator) END)
RETURN @ReturnValue
END