select 'spzj' as 'proname',count(spzz) as 'count',cast(count(spzz)*100 as float)) /(count(spzz)+count(hqgj)+count(spgj)+count(hqzz)+count(jjsy)) as 'bl' from VIEW_bjdjbtj
union
select 'hqgj' as 'proname',count(hqgj),(count(spzz)/count(*)) from view_bjdjbtj
得到的结果后，如何格式化输出'bl'列？？使其显示2位小数。
或者有没有更好的方法实现？
---------------------------------------------------------------
convert(decimal(13,2),XXX)
---------------------------------------------------------------
select 'spzj' as 'proname',count(spzz) as 'count',cast(cast(count(spzz)*100 as float)) /(count(spzz)+count(hqgj)+count(spgj)+count(hqzz)+count(jjsy)) as numeric(10,2)) as 'bl' from VIEW_bjdjbtj
union
select 'hqgj' as 'proname',count(hqgj),cast((count(spzz)/count(*)) as numeric(10,2)) from view_bjdjbtj