公式 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)