查询计算的有关问题
日期：2014-05-18 浏览次数：20686 次
查询计算的问题
有几条数据PublishNum、ClinchADealPublishNum、AppealedPublishNum列都有值，但是计算出来为0，请大牛们解答，非常感谢
------解决方案--------------------
- SQL code
查询语句：
SELECT *,
dbo.F_GetSuccessTradeProportion(vmt.ClinchADealPublishNum, vmt.PublishNum) AS SuccessTradeProportion,
dbo.F_GetSuccessTradeProportion(vmt.AppealedPublishNum, vmt.PublishNum) AS AppealTradeProportion
from
##VendorMangerTable vmt
F_GetSuccessTradeProportion函数：
Create FUNCTION F_GetSuccessTradeProportion
(
@SuccessOrAppealPublishNum INT,
@PublishNum INT
)
RETURNS FLOAT
AS
BEGIN
DECLARE @proportion FLOAT
IF @PublishNum<>0 AND @PublishNum IS NOT NULL AND @SuccessOrAppealPublishNum IS NOT NULL
SET @proportion= CAST(@SuccessOrAppealPublishNum/@PublishNum*100 AS FLOAT)
ELSE
SET @proportion=0
RETURN @proportion
END
有几条数据PublishNum、ClinchADealPublishNum、AppealedPublishNum列都有值，但是计算出来为0，请大牛们解答，非常感谢
------解决方案--------------------
- SQL code
F_GetSuccessTradeProportion函数：
Create FUNCTION F_GetSuccessTradeProportion
(
@SuccessOrAppealPublishNum INT,
@PublishNum INT
)
RETURNS FLOAT
AS
BEGIN
DECLARE @proportion FLOAT
IF @PublishNum<>0 AND @PublishNum IS NOT NULL AND @SuccessOrAppealPublishNum IS NOT NULL
SET @proportion= CAST(@SuccessOrAppealPublishNum AS FLOAT)/@PublishNum*100
ELSE
SET @proportion=0
RETURN @proportion
END
--try
------解决方案--------------------
- SQL code
--应是转换问题，按你的写法@SuccessOrAppealPublishNum小于@PublishNum时就会是0，这样试下
CAST(@SuccessOrAppealPublishNum/(@PublishNum*1.0)*100 AS FLOAT)
免责声明： 本文仅代表作者个人观点，与爱易网无关。其原创性以及文中陈述文字和内容未经本站证实，对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺，请读者仅作参考，并请自行核实相关内容。
