公式： 産出數 / (産出數 + 不良品數)
代碼
CREATE FUNCTION [dbo].[udf_QualityLevel]
(
@OutputQuantity DECIMAL(18,6),
@DefectQuantity DECIMAL(18,6)
)
RETURNS DECIMAL(18,6)
AS
BEGIN
DECLARE @ReturnValue DECIMAL(18,6)
--計算總産出
DECLARE @GrossOutput DECIMAL(18,6)
SET @GrossOutput = (ISNULL(@OutputQuantity,0) + ISNULL(@DefectQuantity,0))
--計算品質水準
SELECT @ReturnValue=(CASE WHEN @GrossOutput = 0 THEN NULL WHEN @GrossOutput IS NULL THEN NULL WHEN @GrossOutput <> 0 THEN (ISNULL(@OutputQuantity,0) / @GrossOutput) END)
RETURN @ReturnValue
END