DECLARE @SqlStr VARCHAR(1000);
SET @SqlStr='
DECLARE @COUNT INT;
SELECT @COUNT=COUNT(*)
FROM ProZone
WHERE 区间 IS NOT NULL
SELECT A.区间 RACH报告的PCCPCHRSCP区间,ISNULL(建立失败次数,0) RAB建立失败次数,
CONVERT(VARCHAR(20),CONVERT(NUMERIC(4,2),CASE ISNULL(建立失败次数,0) WHEN 0 THEN 0 ELSE ISNULL(建立失败次数,0)/@COUNT*100 END))+''%'' RAB建立失败占比
FROM NeedZone A LEFT JOIN
(SELECT 区间, CONVERT(FLOAT,COUNT(*))AS 建立失败次数
FROM ProZone
WHERE 区间 IS NOT NULL
GROUP BY 区间
)C ON A.区间=C.区间
'
EXEC(@SqlStr)