试图如下:
SELECT bal.FBalID, bal.FAssetID, bal.FYear,bal.FDeprPeriods, bal.FNumP, bc.FAssetNumber, bc.FAssetName, bc.FUnit,
bc.FModel
FROM dbo.t_FABalance bal LEFT OUTER JOIN
dbo.t_FABalCard bc ON bal.FBalID = bc.FBalID现在由于数据库的设置问题,在数量BAL。FNUMP里显示的所有小数是如3。00我想让试图显示出整数3,而不要后面的小数,还有怎么把BC。FASSETNUMBER中显示期数的如121期(一期是一个月,6个月以下为0年,6个月以上为一年),变成10年
如果试图不能变,我该怎么实现我所要的格式!数据库是不能变的!
麻烦了啊,!!
bc.FModel
FROM dbo.t_FABalance bal LEFT OUTER JOIN
dbo.t_FABalCard bc ON bal.FBalID = bc.FBalID
FNumP=cast(bal.FNumP as int),FAssetNumber=(bc.FAssetNumber/10+(case when bc.FAssetNumber%10<6 then 0 else 1 end)),
bc.FAssetName, bc.FUnit, bc.FModel
FROM dbo.t_FABalance bal LEFT OUTER JOIN
dbo.t_FABalCard bc ON bal.FBalID = bc.FBalID
SELECT bal.FBalID, bal.FAssetID, bal.FYear,bal.FDeprPeriods, floor(bal.FNumP) fnump,
ceiling(bc.FAssetNumber/12) fassetnumber, bc.FAssetName, bc.FUnit,
bc.FModel
FROM dbo.t_FABalance bal LEFT OUTER JOIN
dbo.t_FABalCard bc ON bal.FBalID = bc.FBalID
bal.FAssetID,
bal.FYear,
bal.FDeprPeriods,
cast(bal.FNumP as int) as FNumP,
--bc.FAssetNumber,
(bc.FAssetNumber / 12 + (case when (bc.FAssetNumber % 12) < 6 then 0 else 1 end)) as FAssetNumber
bc.FAssetName,
bc.FUnit,
bc.FModel
FROM dbo.t_FABalance bal LEFT OUTER JOIN dbo.t_FABalCard bc
ON bal.FBalID = bc.FBalID
SELECT bal.FBalID, bal.FAssetID, bal.FYear,bal.FDeprPeriods, floor(bal.FNumP) fnump,
ceiling(bc.FAssetNumber/12) fassetnumber, bc.FAssetName, bc.FUnit,
bc.FModel
FROM dbo.t_FABalance bal LEFT OUTER JOIN
dbo.t_FABalCard bc ON bal.FBalID = bc.FBalID