CREATE  FUNCTION udf_RankDet(@ManagementHierarchy_ID INT)
RETURNS @FCIRank Table
(
FCI_Rank varchar(20)
)

AS
BEGIN

INSERT INTO @FCIRank(FCI_Rank)
SELECT CASE (Fac.MRRCost + Fac.MRRHFuture)
   WHEN 0 THEN
	CASE CAST(Fac.CRV AS FLOAT (2))
		WHEN 0 THEN 'N/A'
		WHEN > 0 THEN 'N/A'
		WHEN < 0 THEN 'N/C'
		ELSE 'N/C'
		END
   WHEN > 0 THEN
	CASE CAST(Fac.CRV AS FLOAT (2))
		WHEN  0 THEN 'Acceptable'
		WHEN > 0 THEN 
		    IF Fac.CRV >= 0.0 AND Fac.CRV <= 0.04
                       THEN 'Acceptable'
		    ELSE IF Fac.CRV > 0.04 AND Fac.CRV <= 0.09 
                       THEN 'Good'
		    ELSE IF Fac.CRV > 0.09 AND Fac.CRV <= 0.14 
                       THEN 'Fair'
		    ELSE IF Fac.CRV > 0.14 THEN 'Poor'
		    ELSE 'N/A'
		WHEN < 0 THEN 'N/A'
		    ELSE 'N/A'
		END
   WHEN < 0 THEN 'N/A'
   ELSE 'N/A'
   END
FROM tblFacility Fac
WHERE Fac.ManagementHierarchy_ID = @ManagementHierarchy_ID

RETURN
END