 |
MS SQL Server :: Formatting Decimal Places In A Query In MS SQL
2 Decimal Places On Sql AVG () Hi, I am trying to get my string to 2 decimal places... Here is the code:string sumSQL = "SELECT CONVERT (float,sum(callTime)/count(callTime)) as CAVG FROM leads where agent = '" + agent + "' and " + dates.Text;
www.bigresource.com |
 |