带小数值的添加 [英] Addtion with decimal values

问题描述

我有一个sql queries.i想要检索小时和分钟。根据客户要求，我想添加这样的显示。



Ex - 它的检索（1281.5270）。它应该检索为1281.275（意味着它应该添加5 + 270 = 275）。我有一个sql quiries--

Hi,
i have one sql queries.i want to retrieve hour and minutes. As per client requirement,i want to add display like this.

Ex--its retrieving like this(1281.5270). it should retrieve as 1281.275(means it should add 5+270=275). i have one sql quiries--

select (cast(Sum(IsNull(Effort1,0))as varchar(50))+''+ cast(Sum(IsNull(Effort1Minutes,0))as varchar(50))) as Total1,
          (cast(Sum(IsNull(Effort2,0))as varchar(50))+''+ cast(Sum(IsNull(Effort2Minutes,0))as varchar(50))) as Total2,
           (cast(Sum(IsNull(Effort3,0))as varchar(50))+''+ cast(Sum(IsNull(Effort3Minutes,0))as varchar(50))) as Total3,
            (cast(Sum(IsNull(Effort4,0))as varchar(50))+''+ cast(Sum(IsNull(Effort4Minutes,0))as varchar(50))) as Total4,
             (cast(Sum(IsNull(Effort5,0))as varchar(50))+''+ cast(Sum(IsNull(Effort5Minutes,0))as varchar(50))) as Total5,
              (cast(Sum(IsNull(Effort6,0))as varchar(50))+''+ cast(Sum(IsNull(Effort6Minutes,0))as varchar(50))) as Total6,
               (cast(Sum(IsNull(Effort7,0))as varchar(50))+''+ cast(Sum(IsNull(Effort7Minutes,0))as varchar(50))) as Total7

    FROM TimeSheetDetail

每当我在quiries.i上面运行时，我得到1281.5270（这个只是连接）。现在我想显示这样的（1281.275）



我将如何添加这个？请回复我

whenever i am running this above quiries.i am getting 1281.5270(this one just only concatination). now i want to display like this(1281.275)

how i will add this ? pls reply me

推荐答案

您的数据库不应该这样做。如果要强制执行一定数量的小数或其他任何内容，则表示层应执行此操作。你的数据本身不应该被截断，它应该保持真正的价值。



是的，你的SQL是一场噩梦。摆脱varchar演员阵容。如何对varchar（50）进行16次转换会给出十进制两边的四位数？另外，为什么你要连接空字符串？

Your database should not do this. If you want to enforce a certain number of decimals, or whatever, your presentation layer should do this. Your data itself should not be truncated, it should remain the real value.

And yes, your SQL is a nightmare. Get rid of the varchar casts. How can 16 casts to varchar(50) give you a four digit number either side of the decimal ? Also, why on earth are you concatenating empty strings ?

这篇关于带小数值的添加的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！