解决sql server除法结果为0的问题

将被除数乘以1.0再去除

例如：select CustomerID,shop,shopquyu,会员编号,会员姓名,会员号码,专属技师,会员总余额,会员到店次数,(select case when (select SUM(会员到店次数) from #TTCustomers) <> 0 then cast(((会员到店次数*1.0)/(select SUM(会员到店次数) from #TTCustomers))  as decimal(3, 2)) else 0 end) as 到店率,消费次数,消费总金额,欠款金额,最后一次消费项目 from #TTCustomers

 

 

sql计算除法保留两位小数

select cast(10*1./4 as decimal(18,2)) from dual