公式 800*8/(23*8) 算出来应该是34.78....

但sql sever却是34.0

我想要原值 或者 保留两位小数

计算公式代码

800*8/((DATEDIFF( day,DATEADD(MM,DATEDIFF(MM,0,GETDATE()),0), DATEADD(DAY,-1,DATEADD(MM,DATEDIFF(MM,0,GETDATE())+1,0)) )+1 

- ( 2 * DATEDIFF( week , DATEADD(MM,DATEDIFF(MM,0,GETDATE()),0) , DATEADD(DAY,-1,DATEADD(MM,DATEDIFF(MM,0,GETDATE())+1,0))) 

+ Case When DATEPART( dw , DATEADD(MM,DATEDIFF(MM,0,GETDATE()),0) ) = 1 Then 1 Else 0 End 

+ Case When DATEPART( dw , DATEADD(DAY,-1,DATEADD(MM,DATEDIFF(MM,0,GETDATE())+1,0)) ) = 7 Then 1 Else 0 End ))*8)