Using round, isnull, and sum in the same select

• David Hall-426383

  SSC Veteran

  Points: 288

  More actions

  August 19, 2016 at 11:55 am

  #316322

  Is this possible? I wish to sum the column, round it, and also account for null values in a single statement, something like

  select isnull(round(sum(column),0) as Total from table where blah = blah

  The statement above does not work, obviously, but what will?

• Luis Cazares

  SSC Guru

  Points: 183706

  More actions

  August 19, 2016 at 12:28 pm

  #1896419

  You're missing the second parameter and closing parenthesis to either ROUND or ISNULL.

  Luis C.
  General Disclaimer:
  Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

  How to post data/code on a forum to get the best help: Option 1 / Option 2